October 2010
Intermediate to advanced
1008 pages
46h 16m
English
In SQL Server 2005 and SQL Server 2008/R2, administrators can reclaim free space from the end of data files to remove unused pages and recover disk space.
However, shrinking data files is not recommended unless the content database has lost at least half of its content. This typically happens after some activities that create white space in the content database, such as moving a site collection from a content database to another one or deleting a massive amount of data. Shrinking SharePoint databases other than content databases is not recommended, because they do not generally experience as many necessary deletions to contain considerable free space.
Read now
Unlock full access