Post reply

How does SQL Server 2000 decide when to grow the DB?

  • January 1, 2006 at 12:30 pm

    #170215

    Basically what the title says. How does SQL Server 2000 decide when to grow the DB. I have a particular setup where I always need more than 5% free in the DB (both data and log), but under certain circumstances (especially when the DB gets bigger than 10 gigs) the Database will not grow when I need it to. I googled this and tried MS website, but I was not able to find the information that I needed. Any help would be appreciated. Thanks for your time.

    -Nebruin

  • January 4, 2006 at 11:10 am

    #612692

    I'm not 100% sure, but it seems that it grows when it needs the space. In other words, you can't set it to be at xx% left. If you always need more than 5%, you can set the growth to be 10% or 15% and then when you ran out of space, it would grow it. Or you could setup a script to check everyday and when you got to 5% or 6%, grow it manually.

    Why do you need 5% free?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply