Shrink SQL Transaction Logs
December 28, 2009 | Posted by Stewart Schatz Here is the t-sql statement used to shrink the SQL transaction logs:
USE <DatabaseName> Go Backup Log <DatabaseName> WITH Truncate_Only DBCC SHRINKFILE(<TransactionLogName>, 1) Go
Categories: logs, sql, sql server, transaction logs | 
Tags: sql | 
No Comments »