Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Blog Post

Core Infrastructure and Security Blog
2 MIN READ

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

ronalg's avatar
ronalg
Icon for Microsoft rankMicrosoft
Feb 08, 2019

First published on MSDN on Sep 20, 2007

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

Updated Apr 28, 2020
Version 3.0