Reclaim Space on SQL Server

knwilson · 08-20-2008, 09:05 PM

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

TRYDL · 08-21-2008, 11:29 AM

Quote:

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....???

Have you had a chance to review this listing of options?

How do I reclaim space in SQL Server?

knwilson · 08-26-2008, 12:19 AM

Thanks for the response. After many hours of hunting and digging, I found the problem with my Db size was related to the purge maintenance plans timing out when attempting to run. The NSMessageQueue was the largest table and the scheduled task to purge this was not working and simply timing out. I ended up running the stored procedure used by the purge task to get rid of all the "closed" events without dealing with the timeouts. Now that the table is under control, the purge maintenance works properly and the database size is once again where it should be..

Thanks again,
Kevin