Shrink SQL Transaction Logs

Calendar December 28, 2009 | Posted by Stewart

Here is the t-sql statement used to shrink the SQL transaction logs:

Use
Go
Backup Log  With Truncate_Only
DBCC SHRINKFILE(, 1)
Go
linkedin Shrink SQL Transaction Logsdigg Shrink SQL Transaction Logsshare save 120 16 Shrink SQL Transaction Logs

Category Categories: logs, sql, sql server, transaction logs  |  Tag Tags:  |  Comments Leave a reply

Leave a Reply