I've got an issue w. my SQL2000 database. The current size of the .mdf file is 97GB. Howerver the backup is only 66GB. In the EM I can shrink the database down to a more manageable 66GB however, everything I've read suggests that shrinking a database is not a good idea. I need to recover the additional space since space will become a problem soon. Can anyone suggest a better method to regain the additional white space?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
To shrink or not to shrink?
- Thread starter dpu
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
The only way to reclaim the white space is to shrink the database. If you need to reclaim the space for another purpose then you should.
It is normally better to leave the white space within the database so that the database doesn't have to take the space back later.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
It is normally better to leave the white space within the database so that the database doesn't have to take the space back later.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question