Move the UIM Database (MS SQL Server)

You can move the UIM database from one SQL server to another.
uim901
You can move the UIM database from one SQL server to another.
Follow these steps:
  1. Log in to Admin Console.
  2. Deactivate any probes that directly access the UIM database, these probes include:
    • ace
    • alarm_enrichment
    • baseline_engine
    • data_engine
    • discovery_server
    • maintenance_mode
    • nas
    • nis_server
    • prediction_engine
    • sla_engine
    • udm_manager
    • trellis
  3. Using the SQL Server Enterprise Manager or SQL Server Management Studio for SQL server 2005/2008, detach the database from the existing database server.
  4. Move the database files (.mdf) and the log file (.ldf) to the new location or new database server.
  5. Using the SQL Server Enterprise Manager or Management Studio, reattach the database from the new location to the database server or the new database server.
  6. Open the data_engine probe configuration GUI, select the Database Configuration folder.
  7. Change the Data Source, User ID, and password to match the new database settings.
  8. Activate the data_engine, and then any other probes that you deactivated.