About
My Name is Thomas Maurer. Work as a System Engineer in Allschwil for a national provider.
Tag Archives: SQL 2005
Shrinking the Transaction Log in SQL Server 2005
Use the MS SQL Server Management Studio EXEC sp_dboption ‘XXX’, ‘trunc. log on chkpt.’, ‘TRUE’ CHECKPOINT DBCC SHRINKFILE (‘XXX_Log’, TRUNCATEONLY) EXEC sp_dboption ‘XXX’, ‘trunc. log on chkpt.’, ‘FALSE’ GO (replace XXX with the database name)
Posted in IT, Microsoft, SQL Server, Software
Tagged Log, Microsoft SQL Server, Microsoft SQL Server 2005, MS SQL, MS SQL Server, MS SQL Server 2005, Shrink, Shrinking, SQL 2005, SQL Server 2005, Transcation
Leave a comment