Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Migrating SharePoint 2007 WSS_Content database to another SQL server instance

Posted on 2014-03-27
5
Medium Priority
?
595 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 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 8

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 2000 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 8

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 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

636 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