Shrinking the transactions log file

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

Dinu August 16, 2007 13:11

Comments

2 comments

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

Brian Donahue August 16, 2007 13:55

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

Dinu August 16, 2007 14:25

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Shrinking the transactions log file

Comments

Add comment