Creating SQL Server Maintenance Plans

Maintaining the Lync Server Back End databases is important to the overall health and performance of a Lync deployment. Yet this is an aspect that frequently gets overlooked, primarily because Lync administrators are kept busy caring for other aspects of the Lync environment.

Fortunately, Microsoft has provided maintenance plans as a way to automate the tasks required to maintain SQL database health. A maintenance plan performs a comprehensive set of SQL Server jobs that run at scheduled intervals. For example, a maintenance plan can include tasks that ensure that databases are performing optimally, are regularly backed up, and are checked for anomalies.

Tip

SQL maintenance plans should be scheduled to run ...

Get Microsoft® Lync® Server 2013 Unleashed Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.