,

Shrinking the Transaction Log in SQL Server 2000

1–2 minutes
No comments on Shrinking the Transaction Log in SQL Server 2000

Here is how you Shrinking Transaction Log SQL Server 2000:

  • Use the SQL Query Analyzer
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO
  • (replace XXX with the database name)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.