first you need to backup the log file using this command
BACKUP LOG TestDB TO DISK='C:\TestDB1.bak'
Second you run the following command to shrink the log file
DBCC SHRINKFILE (
For more information check this link on
Microsfot support http://support.microsoft.com/kb/907511
No comments:
Post a Comment