Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to on backup log
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
00766846
Message ID:
00766875
Vues:
20
Hi Terry:

Truncating the log does not free up disk space. It only frees up space from within the log file so that transactions can be written without having the file size growing.

If you want to reduce the size of the transaction log file, use DBCC SHRINKFILE or DBCC SHRINKDATABASE. You can use DBCC SHRINKFILE to shrink the transaction log file only. Tons of information about these commands can be found in SQL Books Online.

thanks...
Bernard L. Omiple
VFP, SQL Server, Crystal Reports
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform