Managing and Maintaining SQL 2008 R2

To keep Lync Server operating smoothly and with optimal performance, Lync Server administrators should conduct regular maintenance on each SQL Server database. Such maintenance tasks include rebuilding indexes, checking database integrity, updating index statistics, and performing internal consistency checks and backups. Administrators can perform database maintenance tasks either by executing Transact-SQL commands or by running the Database Maintenance Wizard.

This section provides information and recommendations for maintaining the databases that host Lync Server data and configurations. Later in this section, administrators learn how to automate and schedule the major maintenance tasks by creating database ...

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.