Tag
MS SQL Server
3 articles
-
Slipstream SQL Server 2008 SP2 for SCCM 2012
The Release Candidate version of System Center Configuration Manager 2012 requires MS SQL Server 2008 SP2 with Cumulative update package 6. Now this can be a little annoying and will hopefully change to SQL Server 2008 R2…
-
Shrinking the Transaction Log in SQL Server 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’…
-
Shrinking the Transaction Log in SQL Server 2000
Here is how you Shrinking Transaction Log 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)