Restore pre-SP1 backups to an SP1 farm (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010, SharePoint Foundation 2010

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

  1. 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.

  2. 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

  1. 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.

  2. Upgrade the test farm to SP1.

  3. Perform a site collection backup on the test farm. For more information see, Back up a site collection in SharePoint Server 2010.

  4. 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

  1. Attach the pre-SP1 content database to an SP1 farm.

  2. Run the Psconfig Upgrade command to upgrade the content database to SP1. For more information, see Psconfig command-line reference (SharePoint Server 2010).

  3. Detach the content database from the SP1 farm by following the directions in Attach or detach content databases (SharePoint Server 2010).

  4. Recover content from the unattached content database by following the procedure in Recover content from an unattached content database (SharePoint Server 2010).