Tag
MS SQL Server 2005
1 article
-
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’…
