Moving the Data Warehouse and ACS databases in OpsMgr 2007
Instructions for how to move the data warehouse database, and ACS database – have been published.
The Operations Manager 2007 Backup and Recovery Guide has been updated as of December 2007, to include moving the DW and ACS DB's, in addition to the previously published move of the OpsDB.
Perhaps you deployed your databases to interim hardware? Perhaps you outgrew you current disk I/O? Perhaps you want to move to a high availability cluster?