|
Reclaim Space on SQL Server
Hey all,
I have been trying to free up some space on my SQL server and have been unsuccessful. Basically, I have changed all my purging rules, etc., but still need to reclaim the actual drive space previously consumed. I am out of drive space (200Gb drive and 2Gb left free). I have been using the shrink db and shrink file options, but to no avail. Can someone tell me if I need to have more free space available in order to shrink and reclaim all the unused space in the db? Or, is there something else I need to do to get the unused space reclaimed for the OS....???
Thanks,
Kevin
Last edited by knwilson; 08-20-2008 at 09:50 PM..
|