Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Full Recovery Backups
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
Full Recovery Backups
Divers
Thread ID:
00825379
Message ID:
00825379
Vues:
62
I am having a problem with a client's database, and I am a bit confused about Recovery models. When I right-click on the database in EM and select properties, then select Options, the Recovery model says Full. I had understood that when the Full model is chosen, the inactive part of the transaction log is truncated.

I am getting a message from SQL Server that the transaction log is full, and the database is now in single used mode. To make matters worse, the drive where the data is stored only has 5 MB free, due the huge size of the transaction log. I have missed something fundamental about the transaction log. Why is it so large, and what can I (safely) do to shrink it?

Now I just check the maintenance plan they devised, and the plan does not backup the transaction log. What should I do? HELP!
Chris McCandless
Red Sky Software
Répondre
Fil
Voir

Click here to load this message in the networking platform