Maintaining the Lync SQL Databases

An important aspect of the health of any Lync deployment is maintaining the Lync SQL databases. To keep Lync Server operating smoothly and with optimal performance, regular maintenance should be performed on each SQL Server database. Such maintenance tasks include rebuilding indexes, checking database integrity, updating index statistics, and performing internal consistency checks and backups. Database maintenance tasks can be performed either by executing Transact-SQL commands or by running the Database Maintenance Wizard.

This section provides information and recommendations for maintaining the databases that store Lync Server data and configurations. Also, details are provided on how to automate and schedule the major maintenance tasks by creating database maintenance plans through SQL Server Database Maintenance Wizard.