- Use the SQL Query Analyzer
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO
- (replace XXX with the database name)
About
My Name is Thomas Maurer. Work as a System Engineer in Allschwil for a national provider.
Shrinking the Transaction Log in SQL Server 2000
This entry was posted in IT, Microsoft, SQL Server, Software and tagged Log, Microsoft SQL Server 2000, MS SQL Server, Shrinking, SQL Server, SQL Server 2000, Transaction Log. Bookmark the permalink.