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
LVL 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
 
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
The short of it is that you can't really tell SharePoint you've moved anything, so you have to back everything up, restore it on a new server, set up a sql client alias on every web front end in the farm, and then start things back up. Any requests directed to the old database server will get transparently routed to the new one by the SQL client behind SharePoint.

The process is detailed in this TechNet article:

http://technet.microsoft.com/en-us/library/cc512725(v=office.12).aspx

That said, we've done it before via this process and though a bit painstaking, it worked without issue.
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
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 ?
0
 
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
If you're doing a P2V, then you wouldn't need to do anything at all on the Sharepoint front ends - they'll transparently connect to the newly created server (as long as the IP, network name, windows/sql version, and no other properties change).
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
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.
0
 
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
As long as your connection strings use network name and not IP address, I think you'll be fine and the migration of the databases should be transparent to the SharePoint server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.