Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to on backup log
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00766846
Message ID:
00766875
Views:
21
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
Previous
Reply
Map
View

Click here to load this message in the networking platform