Shrink SQL Transaction Logs
December 28, 2009 | Posted by stewart 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 »