Restore pre-SP1 backups to an SP1 farm (SharePoint Server 2010)
Published: August 11, 2011
This article explains how to restore backups of databases that you made on farms before you installed SharePoint 2010 Service Pack 1 (SP1) to farms that have SP1 installed.
The SharePoint 2010 Service Pack 1 (SP1) upgrade process alters the schema of some farm databases and all content databases. Because of these changes, you might need to take additional steps to restore a backup that you made before the farm was upgraded to SP1 to the farm after it is upgraded to SP1. For more information about SP1, see Service Pack 1 (SP1) for SharePoint Foundation 2010 and SharePoint Server 2010.
Important:
|
|---|
|
We strongly recommend that you perform a full backup immediately after you upgrade to SP1. |
In this article:
Restoring a pre-SP1 farm, Web application, or content database backup to an SP1 farm in SharePoint
Before you restore a pre-SP1 farm Web application or content database backup to an SP1 farm environment, you must use the procedure in this section to upgrade the backup to SP1.
To restore a pre-SP1 farm, Web application, or content database backup to an SP1 farm
-
Restore the pre-SP1 farm backup by using the Central Administration Web site or Windows PowerShell. For more information about how to restore a farm backup, see Restore a farm in SharePoint Server 2010.
-
Upgrade the content database to SP1 by running the Psconfig Upgrade command. For more information, see Psconfig command-line reference (SharePoint Server 2010).
Restoring a pre-SP1 site collection backup to an SP1 farm in SharePoint
Before you restore a pre-SP1 farm backup to an SP1 farm environment, you must use the procedure in this section to upgrade the backup to SP1.
Important:
|
|---|
|
You have to complete these procedures on a test farm that does not have SP1 installed. |
To restore a pre-SP1 farm, Web application, or content database backup to an SP1 farm
-
Restore the pre-SP1 site collection backup to a pre-SP1 test farm. For more information see, Restore a site collection in SharePoint Server 2010.
-
Upgrade the test farm to SP1.
-
Perform a site collection backup on the test farm. For more information see, Back up a site collection in SharePoint Server 2010.
-
Restore the site collection backup to the SP1 production farm. For more information see, Restore a site collection in SharePoint Server 2010.
Restoring content from a pre-SP1 unattached content database to an SP1 farm in SharePoint
Before you restore a pre-SP1 farm backup to an SP1 farm environment, you must use the procedure in this section to upgrade the backup to SP1.
To restore a pre-SP1 farm, Web application, or content database backup to an SP1 farm
-
Attach the pre-SP1 content database to an SP1 farm.
-
Run the Psconfig Upgrade command to upgrade the content database to SP1. For more information, see Psconfig command-line reference (SharePoint Server 2010).
-
Detach the content database from the SP1 farm by following the directions in Attach or detach content databases (SharePoint Server 2010).
-
Recover content from the unattached content database by following the procedure in Recover content from an unattached content database (SharePoint Server 2010).

Important: