Recovering a SharePoint Farm Using Databases with SQL Server Aliases
Applies To: System Center Data Protection Manager 2007
Recovering a farm that uses a database with a SQL Server alias
The procedure to recover a farm with SQL Server aliases configured is the same as the procedure to recover a farm without aliases configured.
Before you perform a recovery, ensure that aliases that correspond to the respective databases are configured and each alias refers to the SQL Server instance location hosting the respective database. Select the SQL Server instance in the Recovery Wizard.
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 Server aliases used by using the following command in the DPM Management Shell $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.