How to Protect SQL Server Databases

The steps used to protect SQL Server databases using DPM are almost identical regardless of whether you are trying to only protect databases on a standalone SQL Server instance or on a SQL Server cluster. For the purposes of this example, the following steps describe how to protect a database located on a standalone SQL Server instance:

1. While logged on to the DPM server as a domain user account that is a member of the local administrators group, open the DPM 2012 Administrator Console.

2. Next, ensure that the SQL Server has the protection agent installed and the agent is reachable with a normal status.

Note

When protecting a SQL Server cluster, all nodes of the cluster should have the DPM protection agent ...

Get Microsoft® System Center 2012 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.