How to shrink the log file
Posted on 2004-10-22
Can anyone advise me how to shrink the log file of a SQL Server database?
I have tried to follow the Microsoft article 272318 "Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE" but to no avail.
When I run the code:
BACKUP LOG Projects WITH TRUNCATE_ONLY
the system tells me that the command has been run successfully but the log file size does not change. Then if I run the code
I get the error message:
"Server: Msg 8985, Level 16, State 1, Line 2
Could not locate file 'Projects_log' in sysfiles."
Can anyone please help?