Chapter 22. Maintaining the Configuration Manager Database through SQL Server

Prevent disaster

Keep the database humming

Make SQL happy!

— Steve Content Publishing Manager Kaczmarek

SQL Server Components

Configuration Manager Database Components

SQL Server Management Tools

Database Maintenance

Backing Up and Restoring the Database

Modifying SQL Server Parameters

Using SQL Replication to Enhance Configuration Manager Site Performance

Summary

Chapter 2, outlined the prerequisites for a computer running Microsoft SQL Server to host the System Center Configuration Manager 2007 site database successfully. Those requirements are recapped here. Recall that Configuration Manager primary sites require an SQL Server 2005 (Service Pack 2 or later) database to store ...

Get Microsoft® System Center Configuration Manager 2007 Administrators Companion 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.

Start your free trial