I have made a VM clone of our production Sharepoint 3.0 server and renamed the server and gave it a different IP, we also backed up the SP DB's and then restored to a different SQL Server the reason for all this is to do some testing without interrupting production. problem now is or my question is How do I point the cloned server to the new DB Server? Do I need to take the server off the network then run the SP config wizard and disconnect from current Farm? Help Please Thanks in Advance

Hi Bobby, To move all the databases in a WSS farm to a new DB server, you need to follow this steps: 1. Prepare the new database server. 2. Stop the farm. Before you can move all the databases, you must stop the farm to ensure that no changes are made while the databases are moved. 3. Back up the following databases: · Content databases · Configuration database · Central Administration content database · Windows SharePoint Services Help Search database 4. Copy or move the database backup files to the destination database server. 5. Restore the databases. 6. Copy to the destination database server all the SQL Server logins, fixed server roles, fixed database roles, and permissions for these databases. 7. Redirect the farm to reference the new database server. 8. Restart the server that is running Central Administration to apply the changes and ensure that the services, Web sites, and application pools that are associated with Windows SharePoint Services 3.0 are started. For more information, please check this Technet article. Thanks. Pengyu Zhao TechNet Community Support

Hi, Yes remove the second server from the farm. Once you are done with it then execute the config wizard in second server and choose connect to an existing farm and this time use other DB server.Thanks, Rahul Rashu

Thanks Rahul, that is pretty much all I wanted to know I wasn't sure if it would affect my production server, and it didn't ThanksBobbyJGR