Tag
Shrinking
2 articles
-
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)