asked on

Migrating SharePoint 2007 WSS_Content database to another SQL server instance

Hi all,

I need to migrate the existing SharePoint 2007 database from one SQL server instance into another one with totally different IP and named instance, so how and where in SharePoint Central Admin site I should change the database to point to the new one ?

FYI: this is WSS 3.0

ASKER CERTIFIED SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

Hi Ryan,

Thanks for the complete reply :-)

In my case, it is just all in one WSS 3.0 server. so if somehow I managed to migrate the database into the same server name (by using Physical to Virtual conversion, only the IP address difference) do I still need to do something on the Sharepoint end ?

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

RyanM,

The IP address will be different but the server name will remains the same.

So can I just shutdown the SharePoint server while I'm doing the changes on the Database server ? After that bring the Sharepoint server back on again.

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial