Here are the simple steps to migrate a content database from one SharePoint 2010 server to another SharePoint 2010 server. Basically this task is divided into two parts:
Part-1: Taking Backup of your content DB using SQL Server Management Studio
Part-2: Restoring Backup file of your content DB to another server using SQL Server Management Studio
Part-1: Taking Backup of your content DB using SQL Server Management Studio
[Server 1]
1. Open SQL Server Management Studio as administrator using your credentials. You can see a list of databases available on your server, select the database of which you want to take backup.
2. Right click to your content DB then go to
Tasks > Back Up…
Below screen will appear.
Click OK.
Click Ok again. Backup is done, copy the backup file (.bak) and move it to the server where you to restore.
Part-2: Restoring Backup file of content DB to new server using SQL Server Management Studio
[Server 2]
1. Open SQL Server Management Studio as administrator using your credentials. Right click Databases, and then go to Restore Database
2. Select the file using “From device” option and click OK.
On successfully completion of restore a pop-up message will appear with the message that “Restore of content database ContentDBName Completed successfully”.
Now your content database is available on another server. And now we are going to replace the newly added content database with old one.
3. Go to
Central Administration > Manage Content Databases
Select the web application
4. Click on content database and check “Remove content database” and click ok. This will remove the existing content database.
5. Click “Add a content database” and enter newly restored content database name.
And click ok.
6. Go to the SharePoint site to see changes.
Server 2(new):
No comments:
Post a Comment