Our SharePoint (WSS 3.0) databases are on a SQL-2000 server that's starting to get low on disk space. In order to buy some time to move content into either our MOSS or SP-2010 environment we did some cleanup in SharePoint by archiving & removing
several old sites and removing older document versions in a couple of libraries. These changes were made 3 days ago. The Site Settings | Storage Space Allocation page indicates that content size is a little under 37 GB, down from a bit more than 40 GB. (I
did make sure that the deleted files / versions were also removed from the site collection recycle bin.)
What has us puzzled is that the physical database file on the SQL Server has not gotten smaller and the amount of "free space" that can be reclaimed has actually gone down - it's currently at about 200 MB. The database file size is over 57 GB; 20 GB larger
than SharePoint reports.
So, I have a few questions:
- Is it normal for the content database file size to be significantly (50-60%) larger than the amount of content that SharePoint reports?
- Is it normal for the database not to get smaller (or at least have more internal free space) when a large amount of content is removed?
- Is there any way that we can recover some of this space to get some breathing room on the SQL Server?
View Complete Post