Do you want to truncate the log file or shrink it? Truncating will remove any completed transactions but won't cause the file size to be reduced. Shrinking will reduce the file size.

if you want to shrink the size of the transaction log, check out the topic Shrinking the Transaction Log in the BOL. You'll probably have to truncate the log first.

why is you log so big? have you been doing log backups? do you have an open transaction that is preventing the file from being truncated? Use DBCC OPENTRAN() to verify that you don't have any open transactions.

-Mike


>Hi All:
> My Transactions log file .LDF is 65 GB. I want to truncate this file. How can I accomplish this? What happens if I just delete the .LDF file from the sql server? Would this have a negative effect on the server? DO I need to have the .LDF file?
>Thanks
>MA