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