Solved

Migrating SharePoint 2007 WSS_Content database to another SQL server instance

Posted on 2014-03-27
5
557 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSAS Store Forecasting data in the cube 1 18
Download ms sql express. 2 28
Dynamic SQL select query 4 38
question about results where i dont have a match 3 23
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
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…

828 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