Using MOSS 2K7 on win 2k8, sql 2k8 running on win 2k8 new db server will also be sql 2k8 on win 2k8. I tried the following http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/ Specifically nstructions for moving a configuration database from one SQL server to another Backup configuration database from the source SQL server Restore the backup onto the target SQL server (Note: this is your opportunity to rename the config database if desired) Run the following stsadm commands from the command line on your SharePoint server to complete the move: (Note: the deleteconfigdb does not actually delete the database from SQL server, it simply disconnects the database from SharePoint) stsadm -o deleteconfigdb stsadm –o setconfigdb -connect –databaseserver target_SQL_server -databasename databasename -farmuser your_farm_sql_account -farmpassword your_farm_sql_password --- The first delete command works. When I run the second command I get: Sharepoint_config on sharepointsqlserver contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database. Is anyone familiar with this method of moving or have a better idea? Just doing this in test for now. Thanks!

Hi,The configuration database and the Central Administration content database contain computer-specific information. Therefore, you can restore them only to an environment that you configure to be precisely the same, including all software updates, server names, and numbers of servershttp://technet.microsoft.com/en-us/library/cc512815.aspxI would recommend creating a new Configuration DatabaseBest Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.

Hi,the steps I would follow is --1> note down the content databases and the web applications they are linked to in the current server farm. I assume that the sharepoint server (web server) is the same one.2> take the backups of the content databases of the web applications and other dbs associated with the sharepoint site. There is no need to take the backup oof the sharepoint config db and the CA content db.3> Restore the databases on the new SQL server.4> Now disconnect the sharepoint server from the current server farm by running the configuration wizard.5> Once disconnected, run the configuration wizard again and select create new ssharepoint farm option.6> once selected, it shall go ahead and create the sharepoint config and the CA content db. make a note that the service account used for sharepoint configuration has got sufficient permissions on the new SQL box.7> Once the configuration is completed, go ahead and create the web applications as per the names you had noted down in step 1. then attach the respective content dbs.Hope this helps...