Shrink SQL Transaction Logs
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
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