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: |
| [ ] Configure the farm services. |
| Create Web applications: |
| [ ] Create the Shared Services Provider. Note: |
|---|
| 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.
Note: |
|---|
| 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