Change the SQL Server in a MOSS 2007/WSS 3.0 Farm


There are several articles out there that tell you how to change the SQL Server for SPS2003 and WSS 2.0. When I ran into this on a customer site, I couldn't find an article that said how to do it for MOSS 2007 and WSS 3.0. I don't have the time at the moment to write up a nice guide, so I'll just write the quick and dirty steps now.

1. Backup the entire farm using the GUI based tool on the Operations tab in Central Administration. (Make sure it completes successfully)
2. Remove all the MOSS machines from the farm
    a. Remove the Incoming and Outgoing email settings
    b. Using the SharePoint Product Technology Configuration Wizard, remove each machine from the farm.
3. Create a new configuration database
    a. Use the SharePoint Product Technology Configuration Wizard to create a new farm, creating a new Configuration Database, ON THE NEW DATABASE SERVER
4. Attach the rest of the servers to the new farm usng the SharePoint Product Technology Configuration Wizard
5. Restore the backup taken in step 1, using the Restore feature on the Operations tab in Central Administration.
    a. Ensure the MOSS Search Service is started on the farm
    b. Ensure the Windows SharePoint Services Administrative Service (Windows Services) is started on the farm


You can also do this with STSADM, but again, that might come in the form of an update to this post. Here are a couple articles that have some pointers if you're having issues doing this.

Restore Office SharePoint Server 2007 by using Central Administration
http://technet2.microsoft.com/Office/en-us/library/83a51073-4cf3-4178-bab3-de2421a727641033.mspx?mfr=true

Restore Office SharePoint Server 2007 by using built-in tools
http://technet2.microsoft.com/Office/en-us/library/47be69f5-aee1-4e77-aff4-a08c536584c91033.mspx?mfr=true

Administering backup and recovery for Office SharePoint Server 2007
http://technet2.microsoft.com/Office/en-us/library/32a18803-52d2-4967-ab9d-0e199c9bf0041033.mspx?mfr=true

Comments (5)

  1. I get a lot of emails and comments asking for a followup to my original post on migrating SharePoint

  2. I get a lot of emails and comments asking for a followup to my original post on migrating SharePoint

  3. Adna Ahmed SharePoint Consultant (www.mossgurus.com) says:

    Hi Ron,

    To extend your post, I think following steps needs to be followed to completely move to new SQL Server database environment.

       6. Run Full Crawl of SharePoint Search and make sure that search configuration is not effected by this change

       7. deploy all custom developed controls again because as soon as you disconnect a SharePoint Server from a web farm all solutions will also be removed from that server.

    Thanks

    Adnan Ahmed

    SharePoint Consultant

    http://www.mossgurus.com

  4. SharePoint 2013 Online Training says:

    I absolutely love your blog and find nearly all of your post’s to be precisely what I’m looking for.

    <a href="http://staygreenacademy.com">SharePoint 2013 Online Training</a>

Skip to main content