Registered member login:
Register Now
Altirigos » Homepage2

» Current Poll
Vista?
Staying on XP until Windows 7 - 71.74%
99 Votes
Already on Vista - 10.87%
15 Votes
Planning an upgrade to Vista soon - 10.14%
14 Votes
Other (please explain) - 7.25%
10 Votes
Total Votes: 138
You may not vote on this poll.
» Stats
Members: 6,825
Threads: 9,759
Posts: 47,766
Top Poster: Nick (4,800)
Welcome our newest member, aric galloso
» Online Users: 21
2 members and 19 guests
cosp, ittcs
Most users online at once 294, 06-30-2007 at 01:24 PM.
» January 2009
S M T W T F S
28293031 1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
View Single Post
Old 08-20-2008, 09:05 PM   #1 (permalink)
knwilson
 
Status: Super Altiris Admin
Join Date: 04-19-2005
Location: Arizona
Age: 33
Posts: 186


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..
knwilson is offline   Reply With Quote
 
Powered by vBadvanced CMPS v3.0 RC2

All times are GMT -4. The time now is 02:15 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
vB.Sponsors
Altirigos