Recovering a SharePoint Farm Using Mirrored Databases
Applies To: System Center Data Protection Manager 2007
Recovering a farm with mirrored database to original location
The procedure to recover a farm with a mirrored database is the same as the procedure to recover a farm with standalone databases. However, when you select a farm with mirrored database in the Recovery wizard, DPM lists all mirrored databases in a table. In the last column of the table, you can select the mirror from which to recover the database. The default selection is the partner from which the database was last backed up.
Before performing a recovery ensure that aliases corresponding to the mirrored databases are configured and each alias refers to the SQL Server instance location hosting the principal/active database. Select the SQL Server instance in the Recovery Wizard page.
Otherwise the farm recovery fails at the end as it is not able to attach the databases after recovery.
You can retrieve all the SQL aliases used using the following command
$RecoveryPoint.GetSqlaliases().
To enumerate $RecoveryPoint, you must start by retrieving the protection groups. For more information, refer to the DPM Management Shell Help using the following cmdlet
get-help get-recoverypoint -full.
Recovering an individual content database
The procedure to recover an individual SharePoint database is the same as recovering a SQL Server database.
Note
You cannot recover an individual SharePoint mirrored database to the original location. Only the ‘Recover to alternate location’ option is available.