Travis Wright from System Center Service Manager team released an articles how to move Service Manager and Datawarehouse databases. If you are faced with such task click on the link below:

http://blogs.technet.com/b/servicemanager/archive/2012/04/22/moving-the-service-manager-and-dw-databases.aspx