About
My Name is Thomas Maurer. Work as a System Engineer in Allschwil for a national provider.
Category Archives: SQL Server
How to integrate (slipstream) SQL Server 2008 and SP1
To install SQL Server 2008 on a Windows Server 2008 R2 you need a slipstream version of SQL Server 2008 with integrated Servicepack 1. At the moment you can’t download SQL Server 2008 with integrated SP1, so you have to … Continue reading
Posted in IT, Microsoft, SQL Server, Software, Windows Server 2008 R2, Work
Tagged HowTo, MS SQL 2008, MS SQL Server 2008, MS SQL Server 2008 SP1, Slipstream, SP1, SQL, SQL 2008, SQL Server
1 Comment
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