About
My Name is Thomas Maurer. Work as a System Engineer in Allschwil for a national provider.
Tag Archives: MS SQL Server
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
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 Log, Microsoft SQL Server 2000, MS SQL Server, Shrinking, SQL Server, SQL Server 2000, Transaction Log
Leave a comment