Log File how i prevent form growing

nav_studentnav_student Member Posts: 175
edited 2014-03-02 in SQL General
Helo guyi have SQL 2008 R2.

My database is about 25GB, Recovery Model is Full, and the Log File is set to a Initial Size of 1GB and the Autogrowth By 1000MB to a restricted growth 2097152MB.

In a couple of hours the Log (as the Initial Size) is 4GB. Can you tell me why?

How can i prevent this quick growth?

Thanks for your help :)

Comments

Sign In or Register to comment.