Shrinking the transactions log file

Dinu

One of our databases has the size of the mdf file 13MB and the size of the ldf file 4GB
After full backup I used the SQL Server shrink function. The effect was minimal.

What should I do to reduce the size of the ldf file?

Thanks Dinu

Brian Donahue

Hi Dinu,

If the database is using the FULL recovery model, backing up the transaction logs will allow the LDF file to shrink. Please see this article for more information:

http://www.red-gate.com/support/kb/KB200707000076.htm

Dinu

Thank you very much Brian for your prompt reply.
Problem solved!
Dinu