Recovering a SharePoint Farm by Using Mirrored Databases
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
Recovering a farm with a mirrored database to its original location
The procedure to recover a farm with a mirrored database is the same as the procedure to recover a farm with stand-alone databases. Additionally you will find the following options when you select the Recover all SharePoint content and components option on the Select Recovery Type page of the Recovery Wizard.
Select this option to recover the mirrored SQL Server databases to the instances of SQL Server that were hosting these databases as the principal database when the selected recovery point was created.
Select this option to recover the mirrored SQL Server databases of the SharePoint farm to the instances of SQL Server. At the point of recovery point creation, for each mirrored SQL Server database, you can select either of its partner instances of SQL Server (principal/mirror). Before you select the instance of SQL Server, make sure of the following:
The default selection is the partner from which the database was last backed up.
If you are using a SQL Server alias for the mirrored database, then before the recovery ensure that aliases corresponding to the respective databases are configured such that they refer to the SQL Server instance location selected on the Recovery Wizard page.
Otherwise the farm recovery fails at the end because it cannot attach the databases after recovery. For more information, see Recovering a SharePoint Farm by Using Databases with SQL Server Aliases.
ConceptsRecovering SharePoint Data
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.