SharePoint By Yagya Shree

How to move content database from one SQL server to another SQL server and get the sharepoint site collection up & running

leave a comment »

1. Backup you content database from old SQL server. If you already have a backup no need to do this step.

2. Restore the database on the new SQL server and note down the name of the database

3. Go to your Central administration–application management–create and extend site, create a new web application and give the database name as “dummydatabase”. you can use any service account who is the farm administrator

4. Now go to Central Administration–application management–content databases, Here change it to the newly created web application

5. Here put the check mark in “Remove content database” and click “Ok”

6. Now open your command prompt and go to “C:\program files\common files\microsoft shared\web server extensions\12\bin”

7. Run the following command

stsadm.exe -o addcontentdb -url <new web application name> -databasename <new restored database name>



Written by Yagyashree

June 2, 2009 at 1:45 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: