Click to Rate and Give Feedback
TechNet
TechNet Library
Office
Office System
SharePoint Server
Operations
Migrating servers and server farms (Office SharePoint Server 2007)

Updated: 2008-08-07

For this task, the term migrate means to restore your data by moving to another server. You can move server farms, Web applications, content databases, and Project databases. A typical reason for migration is moving from a test environment to production but there might be many other reasons for you to do this. You can migrate by using the built-in tools that are installed with Microsoft Office SharePoint Server 2007 — the SharePoint Central Administration Web site or the Stsadm command-line tool.

Prepare to migrate

If this will be the only instance or it is the first instance of Microsoft Office SharePoint Server 2007 to be installed on the server farm, do the following:

On the destination server farm:

[ ] Run Setup and select the Complete Server Installation Type.

Run the SharePoint Products and Technologies Configuration Wizard:

  • [ ] Create a new farm

  • [ ] Create a new Configuration database

[ ] Configure the farm services.

Create Web applications:

  • [ ] Create a Web application for the Shared Services Provider

  • [ ] Create a Web application for other content as needed

[ ] Create the Shared Services Provider.

NoteNote:

You can migrate the Shared Services Provider database or you can create a new one.

This is a general checklist of the steps needed to prepare the server farm for migration. For more detailed information about installing Office SharePoint Server 2007, see Deployment for Office SharePoint Server 2007.

Task requirements

The following is required to perform the procedures for this task:

  • Membership in the Administrators group on the server computer that has either Windows SharePoint Services 3.0 or one of the server products in the Office 2007 release installed.

  • You must grant the sysadmin fixed server role to the database access account during the migration process. This is required for the account to replicate the security setting for the databases. This access level can be removed after the migration process is complete.

Migrate by using built-in tools

To back up and restore data for Office SharePoint Server 2007, you can use either of the following methods:

  • Migrate to another farm by using the Central Administration Web site (Office SharePoint Server 2007)

    You can use the SharePoint Central Administration Web site to back up and restore Office SharePoint Server 2007. Also, you can use Central Administration to view backup and recovery history and to view backup and recovery job status. When you use this method, you can back up the configuration database, Web applications, and any or all of the content databases in your server farm.

    NoteNote:

    You can back up but you cannot restore a configuration database.

  • Migrate to another farm by using the command line (Office SharePoint Server 2007)

    When you use this method, you can restore Web applications and any or all of the content databases in your server farm. You can use the Stsadm command-line tool to view backup and recovery history and to view backup and recovery job status. This method of backing up and restoring data does not require SQL Server 2000 tools or SQL Server 2005 tools. However, you must still be an administrator on a server computer that has either Windows SharePoint Services 3.0 or one of the server products in the Office 2007 release installed in order to perform this method of backing up and restoring.

  • Migrate to another farm by using SQL Server tools (Office SharePoint Server 2007)

    Using SQL Server Management Studio, you can move a farm by performing a full-fidelity, complete backup and restore of the databases used by Office SharePoint Server 2007. This method of moving databases requires Microsoft SQL Server 2005 (it will not work with Microsoft SQL Server 2005 Express Edition) and you must be a member of the Administrators group on the local server computer that is running SQL Server.

See Also

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker