Friends,

Here is the steps for to move WSS_content Database from one server is other server.

it is dam easy if you want to shift WSS_Contene DB from one server to other server, if you have a PWA is integrate wish MOSS at thsi time you have to take care about all the websites which are Created under PWA.

i am trying to giving you a solution about this , hope it will be helpful to you,

for the precaution first of all we will take backup of all the database and Farm,

before to take backup we will try to saw all the websites under the farm,

stsadm.exe -o enumsubwebs -url http://servername/pwa

1. Take full farm backup from the central admin.
2. Take project server databases backup from SQL i.e. Published,
Draft Archive and Reporting
3. Take stsadm export of the project workspaces.
4. Delete PWA from SSP -> Project Web Access.
5. Now, take backup of the WSS_Content database.
6. Restore the project server databases backed up from SOURCE
SQL Server to DESTINATION SQL Server.
7. Restore the WSS_Content databases backed up from SOURCE
SQL Server to DESTINATION SQL Server.
8. Run following command:
stsadm -o preparetomove -contentdb DATABASESERVERNAME:
WSS_Content -site http://servername
9. Detach the existing WSS_Content database from the web app
using central admin UI.
10. Attach the restored content database to the web app using
following command:
stsadm -o addcontentdb -url http://servername
-databasename WSS_Content -databaseserver
DATABASESERVERNAME
11. Provision the PWA site pointing to the databases restored from
the SSP -> Project Web Access.
12. From the exported workspaces, import them one by one using
following command:
stsadm -o import -url e.g. http://servername:portnumber
/PWA/<Project
Name> -filename .cab

note :- at the time of deteching DB and cleaning all the existing websites please make sure about HDD space 🙂

stsadm.exe -o execadmsvcjob (Kill running process)
stsadm.exe -0 perfoermtomove(before to detach DB)

Kuntal
(Sr. System Administrator)
MCP,MCTS

4 Responses to “restored WSS_Content Database from one server to other server”


  1. Hey, I found your blog while searching on Google your post looks very interesting for me. I will add a backlink and bookmark your site. Keep up the good work!

    Robert Shumake

  2. WP Themes Says:

    Nice dispatch and this post helped me alot in my college assignement. Gratefulness you for your information.

  3. seo Says:

    Can you provide more information on this? cheers

  4. seo Says:

    Can you provide more information on this? take care


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: