Solved

Migrating SharePoint 2007 WSS_Content database to another SQL server instance

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now