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 SERVER4. Attach the rest of the servers to the new farm usng the SharePoint Product Technology Configuration Wizard5. 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 farmYou 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 Administrationhttp://technet2.microsoft.com/Office/en-us/library/83a51073-4cf3-4178-bab3-de2421a727641033.mspx?mfr=trueRestore Office SharePoint Server 2007 by using built-in toolshttp://technet2.microsoft.com/Office/en-us/library/47be69f5-aee1-4e77-aff4-a08c536584c91033.mspx?mfr=trueAdministering backup and recovery for Office SharePoint Server 2007http://technet2.microsoft.com/Office/en-us/library/32a18803-52d2-4967-ab9d-0e199c9bf0041033.mspx?mfr=true
PingBack from http://stevepietrekweblog.wordpress.com/2007/09/20/links-9202007/
I get a lot of emails and comments asking for a followup to my original post on migrating SharePoint
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.