Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2004-05-26 : 09:02:42
|
| I have a database of 30 GB and the free avail. space is around 15 GB in MDF file. The system is running short of data drive space, and I believe I should shrink the db mdf file to free the space. Any comments, suggestions on my approach. Thanks in advance.RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-26 : 09:12:47
|
| DBCC SHRINKFILE(1)You might want to run it 2 or 3 times consecutively.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2004-05-26 : 09:15:34
|
| Thanks Derrick. Can you let me know why do you want it to be run for 2 to 3 times ?RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-26 : 09:17:26
|
| The shrinkfile does not always shrink to the maximum available on the first run. Look at the size of the file each time after you run it. You'll see what I'm talking about.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Database shrinking