Database Sizing Question

  • Thanks Omen... another great tip. Wow, this question has raised some great feedback!

  • The only drawback that I know of to starting out with a larger size vs. smaller and then growing larger is that if you want to shrink the db say to store it on a zip disk, it will only shrink down to the original size, no matter how much empty space remains.

  • hlx you are correct, except there are ways with SQL7 and 2000 to shirnk the log below original size and the db. 6.5- are not able to be done.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 16 through 17 (of 17 total)

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