We have Update Manager 4.1 in a vSphere 4.1 environment. We are moving our Update Manager database to a new sql host. Is there any documentation out on moving the databse and what you have to do on the host with Update Manager installed (our vCenter server) to reconfigure it to use the moved database? I looked in the KB and didn't find any information. There is a kb on moving the vCenter db which I'll be doing, but nothing specific to Update Manager.
Manually moving the database and repointing the UM ODBC to the new DB instance should do the trick. As always, a full DB backup and a VM snapshot - should the VC/UM be a VM - is always advisable.