O'Reilly logo

Microsoft® Lync Server 2010 Unleashed by Tom Pacyk, Andrew Abbate, Alex Lewis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required