How to migrate a SharePoint 2007 application across servers or domains
Note: If either the backup or restore fails, you will need to delete the job from Operations, Global Configuration, Timer job definitions before running again
- Backup the application you wish to migrate
- Central Administration, Operations, Backup and Restore Section, Perform a Backup
- Select the sites being migrated and set a destination folder for the backup.
- The destination folder will need the following permissions
- Read/write for the SQL Server process account
- Standard install uses the network service account
(MyDomain/SqlServerName$)
- Read/write for the SharePoint process account
- Restore from backup onto the destination server
- Central Administration, Operations, Backup and Restore Section, Restore from Backup
- Specify the location of the backup files
- Select the backup
- Select the application(s) within the backup that you wish to migrate and click "Continue Restore Process"
- Set your Restore Options
- New Configuration
- Provide credentials for a SQL Server user account or leave blank to use the Sharepoint process account via Windows Authentication
- The account must be a member of the dbcreator role
- Provide the new URL
- User the new http:ComputerName:Port
- Provide the new SQL server name
- Verify the SQL server data directory is correct
- SQL2005 uses a slightly different default path than SQL2000
- Optionally change the Application and Database names
- Click OK to begin the restoration then come back in a half hour to see if it worked.
- If moving to a different domain, use an account with admin on the SharePoint server to configure the new user accounts in each site's People and Groups interface.
