Competition: What’s your favorite Redgate tool? Enter now.

Shrinking the transactions log file

DinuDinu Posts: 6
edited August 16, 2007 2:25PM in SQL Backup Previous Versions
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 E Anastasiu

Comments

Sign In or Register to comment.