This blog post show detailed information: Migrating vCenter Server, Site Recovery Manager and Update Manager 5.0 database from SQL Express 2005 to SQL Server 2008…---1 person found this helpful
Senior Infrastructure Specialist
Before step 4. you have to re-configure the existing ODBC client connection to point to the new DB server.(VMware KB: Verifying ODBC connectivity to the VMware vCenter Site Recovery Manager database ) after step 4 probably you will need also to repair (reconfigure) connection between protection and recovery site.
Hope this help,