|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
June 21st, 2004, 05:26 AM
|
|||
|
|||
|
Database not releasing Free Space
Hi,
I have a database which grows to about 300GBs every month. At the end of every month certain tables within the database are dumped zipped and then deleted from the DB. The problem is after deleting all these tables and several shrinks (carried out through enterprise manager) I have 250GBs of free space showing in Enterprise manager but only 20GB actually showing on the hard disk in My computer. How do I get the Database to rekease all this free space back to the Hard disk itself? Any help appreciated. .logic.
|
|
#2
June 22nd, 2004, 05:47 PM
|
||||
|
||||
|
Consult your SQL Server Books Online for "DBCC SHRINKDATABASE"
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home. "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest Down with Sharon Osbourne Puzzle of the Month solved by sizeablegrin, etienne141 and L7Sqr, superior C/C++ programmers of the month
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Database not releasing Free Space |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
