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)