Redirecting the restore of a SharePoint Server Web application content database to an alternate SQL Server instance
You can redirect a SharePoint Web application content database to an alternate SQL Server instance to take advantage of SharePoint data recovery from an unattached content database. The target database must be a new database.
To redirect the restore of a SharePoint Server database to an alternate SQL Server instance
- Open the Backup, Archive, and Restore interface.
- Click File > Select Files and Folders to Restore > from Normal Backup.
- Select the MS-SharePoint policy type.
- From the NetBackup History pane, select the full backup image that contains the objects you want to restore.
- In the All Folders pane, expand Microsoft SharePoint Resources.
Note:
When you select items to restore, do not check the checkbox for an item in the All folders pane. Only check the checkbox for an item in the Contents of pane.
- In the Contents of pane, select the Web application content database to redirect.
- Click Actions > Restore.
- Click the Microsoft SharePoint tab.
- Click Redirect SharePoint Resources.
- Select Alternate SQL Instance.
- In the SQL Server\Instance box, type the name of the SQL Server and the instance name to which you want to redirect the Web application content database.
- In the Target Database box, indicate the name of the target database.
- Click Start Restore.