Restore a Site Content Database

Stand-alone or Single server with SQL Server Deployments

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Site Content Database restore is part of Portal Site Restore do not restore the Site Content database before the Portal Site Restore.
• If the Site Content Database was removed from the Virtual Server but the database was not deleted from the SQL Instance, delete it before beginning the restore (for Stand-alone or Single server with SQL Server Deployments).

Required Capability: See Capabilities and Permitted Actions

To restore the Site Content database:

1. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
2. From the Browse Data window, expand the Portal Site node and select Site Content Database.
3. From the Restore Options dialog box, enter the required information in the Restore Options Site Content Databases tab.
4. Continue with the restore procedure.

Server Farm (Small, Medium, Large)

Before You Begin:

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• If the Site Content Database restore is part of Portal Site Restore do not restore the Site Content database before the Portal Site Restore.

Required Capability: See Capabilities and Permitted Actions

To restore the Site Content database:

1. Restore the Site Content Databases using the SQL iDataAgent. Refer to Recovering a Database for step-by-step instructions. Do not restore the SharePoint Configuration Database.
2. Begin a restore procedure using the SharePoint Server iDataAgent. See Browse and Restore for step-by-step instructions.
3. From the Browse Data window, expand the Portal Site node and select Site Content Database.
4. From the Restore Options dialog box, enter the required information in the Restore Options Site Content Databases tab.
5. Continue with the restore procedure.