Execute the following commands:
|
1 2 3 4 |
DBCC SHRINKFILE(pubs_log, 2) BACKUP LOG pubs WITH TRUNCATE_ONLY DBCC SHRINKFILE(pubs_log,2) |
This will reduce the transaction log for the “pubs” database to 2MB.
MS-SQL 2000 : Truncate transaction log
Have a project or a problem?
Talk with a senior engineer for practical recommendations—no obligation.
Leave a comment
Related Posts
Reliable Penguin provides managed web hosting, systems administration, website and server migrations, and expert consulting.
Recent Updates
March 5, 2026
February 25, 2026
February 25, 2026
