Moving the SharePoint Databases to a new SQL server instance

(Updated 20071004) Well, you just have a brand new database server and you need to move all the databases from your old SQL server to the new SQL server. This is what I did to change the SQL server instance of an existing EPM farm. You cannot just backup and restore (or detach it) the databases….