Microsoft have launch documentation "Moving all databases to a different database server or a server with the same name" about SharePoint Databases.
This is great, have a lot of calls about moving databases.... belive me, i saw some terrible things people make in SQL server.....
Hope this help...
