Restore a Web application in SharePoint Server 2010
Applies to: SharePoint Server 2010, SharePoint Foundation 2010
This article describes how to restore a Web application. When you restore a Web application, you also restore the Internet Information Services (IIS) settings and all content databases that are associated with the Web application.
In this article:
Considerations when restoring a Web application
Use Windows PowerShell to restore a Web application
Use Central Administration to restore a Web application
Use SQL Server tools to restore databases associated with a Web application
Additional steps to restore a Web application that uses forms-based authentication
Additional steps to remove duplicate claims providers after restoring a Web application that uses claims-based authentication
Additional steps to re-create object cache user accounts
Considerations when restoring a Web application in SharePoint
Consider the following information as you prepare to restore a Web application:
You can only restore one Web application at a time by using the procedures in this article. However, you can simultaneously restore all the Web applications in the farm by restoring the complete farm.
If a Web application uses the object cache, you must manually configure two special user accounts for the Web application after you restore the Web application. For more information about the object cache and how to configure these user accounts, see Configure object cache user accounts.
You cannot use SQL Server tools to restore a Web application.
When you restore a Web application that is configured to use claims-based authentication, there are additional steps that you must follow after restoring the Web application to restore claims-based authentication.
Use Windows PowerShell to restore a Web application in SharePoint
You can use Windows PowerShell to restore a Web application manually or as part of a script that can be run at scheduled intervals.
To restore a Web application by using Windows PowerShell
Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
On the Start menu, click All Programs.
Click Microsoft SharePoint 2010 Products.
Click SharePoint 2010 Management Shell.
At the Windows PowerShell command prompt, type the following command:
Restore-SPFarm -Directory <BackupFolderName> -RestoreMethod Overwrite -Item <WebApplicationName> [-BackupId <GUID>] [-Verbose]
<BackupFolderName> is the full path to the folder you use for backup files.
<WebApplicationName> is the name of the Web application that was backed up.
<GUID> is the identifier of the back up to use for the restore operation.
If you do not specify the value of the
BackupIDparameter, the most recent backup will be used. You cannot restore a Web application by using a configuration-only backup. You can view the backups for the farm by typing the following:
Get-SPBackupHistory -Directory <BackupFolderName> -ShowBackup
For more information, see Restore-SPFarm.
We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.
Use Central Administration to restore a Web application in SharePoint
You can use Central Administration to restore a Web application.
To restore a Web application by using Central Administration
Verify that the user account performing this procedure is a member of the Farm Administrators group. Additionally, verify that the Windows SharePoint Services Timer V4 service and the Farm Database Access account have Full Control permissions on the backup folder.
In Central Administration, on the Home page, in the Backup and Restore section, click Restore from a backup.
On the Restore from Backup — Step 1 of 3: Select Backup to Restore page, from the list of backups, select the backup job that contains the farm or Web application backup, and then click Next. You can view more details about each backup by clicking the (+) next to the backup.
If the correct backup job does not appear, in the Current Directory Location text box, type the Universal Naming Convention (UNC) path of the correct backup folder, and then click Refresh.
You cannot use a configuration-only backup to restore the Web application.
On the Restore from Backup — Step 2 of 3: Select Component to Restore page, select the check box that is next to the Web application, and then click Next.
On the Restore from Backup — Step 3 of 3: Select Restore Options page, in the Restore Component section, make sure that Farm\<Web application> appears in the Restore the following content list.
In the Restore Only Configuration Settings section, make sure that the Restore content and configuration settings option is selected.
In the Restore Options section, under Type of Restore, select the Same configuration option. A dialog box appears that asks you to confirm the operation. Click OK.
If the Restore Only Configuration Settings section does not appear, the backup that you selected is a configuration-only backup. You must select another backup.
Click Start Restore.
You can view the general status of all recovery jobs at the top of the Backup and Restore Job Status page in the Readiness section. You can view the status for the current recovery job in the lower part of the page in the Restore section. The status page updates every 30 seconds automatically. You can manually update the status details by clicking Refresh. Backup and recovery are Timer service jobs. Therefore, it may take several seconds for the recovery to start.
If you receive any errors, you can review them in the Failure Message column of the Backup and Restore Job Status page. You can also find more details in the Sprestore.log file at the UNC path that you specified.
Use SQL Server tools to restore databases associated with a Web application in SharePoint
You cannot restore the complete Web application by using SQL Server tools. However, you can restore all the databases that are associated with the Web application. To restore the complete Web application, use either Windows PowerShell or Central Administration.
To restore databases associated with a Web application by using SQL Server tools
Verify that the user account performing this procedure is a member of the sysadmin fixed server role.
If the Windows SharePoint Services Timer service is running, stop the service and wait for several minutes for any currently running stored procedures to finish. Do not restart the service until after you restore the databases.
Start SQL Server Management Studio and connect to the database server.
In Object Explorer, expand Databases.
Right-click the database that you want to restore, point to Tasks, point to Restore, and then click Database.
The database is automatically taken offline during the recovery operation and cannot be accessed by other processes.
In the Restore Database dialog box, specify the destination and the source, and then select the backup set or sets that you want to restore.
The default values for destination and source are appropriate for most recovery scenarios.
In the Select a page pane, click Options.
In the Restore options section, select only Overwrite the existing database. Unless the environment or policies require otherwise, do not select the other options in this section.
In the Recovery state section:
If you have included all the transaction logs that you must restore, select RECOVER WITH RECOVERY.
If you must restore additional transaction logs, select RECOVER WITH NORECOVERY.
The third option, RECOVER WITH STANDBY is not used in this scenario.
Click OK to complete the recovery operation.
Repeat steps 4 through 10 for each database that you are restoring.
Start the Windows SharePoint Services Timer service.
Additional steps to restore a Web application that uses forms-based authentication in SharePoint
After you restore a Web application that uses forms-based authentication, you must perform the following steps to reconfigure the Web application to use forms-based authentication.
Re-register the membership and role providers in the Web.config file.
Redeploy the providers.
For more information, see Configure forms-based authentication for a claims-based Web application (SharePoint Server 2010).
Additional steps to remove duplicate claims providers after restoring a Web application that uses claims-based authentication in SharePoint
After a Web application that is configured to use claims-based authentication has been restored, duplicate or additional claims providers are often visible. You must use the following process to remove the duplicate providers:
In Central Administration, click Manage Web application, select a Web application that uses claims-based authentication, and then click Authentication Providers.
Select a zone that the Web application is associated with to open the Edit Authentication page, and then click Save.
Repeat for each zone, and then for each Web application that uses claims-based authentication.
Additional steps to re-configure object cache user accounts in SharePoint
If you configured object cache user accounts for the Web application, the restore process will not restore these settings. You must re-configure the settings for the Web application. For more information, see Configure object cache user accounts.
Business Continuity Management for SharePoint Server 2010 (http://go.microsoft.com/fwlink/p/?LinkID=199235)
IT Pro content
Data Protection and Recovery (http://go.microsoft.com/fwlink/p/?LinkID=199237)