Dell PowerVault DP600 - Manual (Page 67)

67
Replacing a Disk on a SQL Server
You might replace a disk on a SQL Server to upgrade capacity or to replace a failed disk. If you
replace a disk that contains SQL Server data protected by DPM, you should assign the same
drive letter to the new disk. You can then recover the protected data from the DPM server to the
new disk.
Adding Databases to a SQL Server
New databases on a protected computer running SQL Server are not automatically added to an
existing protection group. When a new database is created, you should manually add the
database to an existing or new protection group to ensure the data is protected.
Changing the Path of a SQL Server Database
When a path associated with a protected database changes, backup jobs will fail. To resolve this
issue, remove the database from protection and then add the database back to the protection
group. This change to the protection group will require a consistency check. After the consistency
check completes successfully, normal protection jobs will resume.
Renaming a SQL Server Database
If you rename a database that is protected by DPM, you must add the database under its new
name to an existing or new protection group and then remove the database under its old name
from its protection group. The database will be protected as a new data source.
Managing Clustered SQL Servers
On planned failover of a cluster, DPM continues protection. On unplanned failover, DPM issues
an alert that a consistency check is required.
For a non-shared disk cluster, planned failover may also require a consistency check.
You cannot backup and recover the master database for clustered SQL Servers.
In This Section
Changing SQL Server Cluster Members
Changing Resource Groups on Clustered SQL Servers
Changing SQL Server Cluster Members
When you make changes to a server cluster that is protected by DPM, DPM takes the following
actions:
• When a new server is added to a cluster, DPM issues an alert to install a protection agent on
the new cluster node and protection fails.