Adding Databases to a SQL Server

適用於: System Center Data Protection Manager 2010

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