Transaction Log

[ninelgorb]

I have a database whose transaction log is 22867.367 mb. I need to truncate it. I used the following command:
backup log mydatabase with truncate_only and the only difference I noticed was that the Log Space Used went down. The Log size didn't change.

What commands should I be using to truncate the transaction log?

 

[SQLBill]

You did truncate the log. All truncate does is remove data from the log file.

To get rid of the unused space, use DBCC SHRINKFILE. Refer to the BOL for more information.

-SQLBill

Posting advice: FAQ481-4875