Tag

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’…