Shrinking Data Files
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.
Caution
However, shrinking data files is not recommended unless the content database has lost at least half of its content. This typically happens after activities that create whitespace 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 Lync Server databases other than content databases is not recommended because they do not generally experience as many necessary deletions to contain considerable free space.
Shrinking a Database by Using SQL Server 2008 R2 Management Studio ...
Get Microsoft® Lync Server 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
