Solved

Migrating SharePoint 2007 WSS_Content database to another SQL server instance

Posted on 2014-03-27
5
560 Views
Last Modified: 2014-04-15
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
0
Comment
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 39965770
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
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39965813
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
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 500 total points
ID: 39966558
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
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 39967764
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
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 500 total points
ID: 39967896
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question