Moving WSS 3.0 and MOSS 2007 content databases

One of the questions that my I usually encountered during conferences is whether we can move WSS 3.0 or MOSS 2007 content databases from one SQL Server to another. If you’ve ever wanted to relocate your WSS 3.0 or MOSS 2007 content databases from one SQL server to another, the steps are fairly simple.

Step 1: Detach the content database from the source SQL server and copy the .mdf and .ldf to the target SQL server.

Step 2: Attach the .mdf and .ldf files on the target SQL server as a new database.

Step 3: Run the following stsadm commands from the command line on your SharePoint server to complete the move:

stsadm –o deletecontentdb –url http://<yoursiteurl> –databasename <your_content_database> –databaseserver <your_source_SQL_server>

stsadm –o addcontentdb –url http://<yoursiteurl> –databasename <your_content_database> –databaseserver <your_target_SQL_server>

Advertisements

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: