Tag Archives: Microsoft SQL Server 2000

Shrinking the Transaction Log in 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)

Posted in IT, Microsoft, SQL Server, Software | Tagged , , , , , , | Leave a comment