Add databases to a SQL Server

Updated: November 1, 2013

Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager

System Center 2012 – Data Protection Manager (DPM) allows you to protect SQL Server databases through SQL Server instance auto-protection. This enables DPM to automatically identify and protect SQL Server databases that are added to instances of SQL Server to be automatically protected.

Enabling SQL Server Instance Auto-Protection

SQL Server instance auto-protection is turned on by default for any instance of SQL Server that you protect. When you add an instance of SQL Server to a protection group, auto-protection is automatically enabled on the instance.

You can use the cmdlet Start-AutoProtection to force DPM to immediately check for new databases and add them to protection if you cannot wait for the nightly job.

Disabling SQL Server Instance Auto-Protection

To disable auto-protection for SQL Server instance, right-click the instance on the Create Protection Wizard or on the Modify Protection Wizard, and then select Turn off auto-protection. When you turn off auto-protection for an instance of SQL Server, DPM will not discover any new databases created on that instance. To protect any new databases, you must manually add them to the protection group.

For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.