Can you shrink Transaction Logs? I thought one could only shrink database files? If so can anyone help me with how to shrink Transaction Logs, a scripts will be highly appreciated .

Regards,

CarlWalden

__________________
CarlWalden

Hi,

you can find that in Sql Server Books online (it's part of sql server instalation) -> Index -> shrinking transaction logs or you can set your database recovery model to simple (Specify that the transaction log is truncated when the checkpoint process occurs).

Regards,

Nuno

You can detach the database, delete the transaction log file (ldf) and reattach the database using sp_attach_singlefile_db. This will create a new transaction log file that is very small.

If you have a lot of bulk transcations you might want to set your recover settings on the database to Bulked Log.