binary lumberjack (1/19/2009)
You can't shrink below the initial size. Your only option is to back up the database, drop and recreate it with a lower initial size, and then restore. You should only set the initial size when you know you will always need at least that much space.
Again - if you use shrinkdatabase, that might be true, but shrinkfile DOES in fact allow you to make the initial size smaller.....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?