shrink database - reclaim space, but leave room too
Posted on 2006-11-16
i'm shrinking a database which brings my 9GB db to 3GB (lots of extra tables were truncated since they're not needed...and shrinking reclaims the space).
however i understand that's not always desirable; sometimes it's good to leave space (that can be filled in by new records later).
BUT - if you don't reclaim the space (and in my case above) you're left with the larger database even though you want to slim it down some.
is there a happy medium? is there a way to determine how much page space to leave so that you don't have as many fragmentation issues?