Moving the UIM database from one location/database server to another

book

Article ID: 34719

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

How can I move my UIM database from one server/location to another?

 

Environment

Release:
Component: CAUIM

Resolution

(Note: the below instructions reference Microsoft SQL Server, but the procedure is the same for all database platforms; please consult your DBA for assistance with the details.)

  1. Install SQL server on the new machine if it isn't already installed.
  2. On the primary hub/UIM server, stop the Robot Watcher service, shutting the robot down entirely.  Also shut down the robot on your UMP server if applicable.
  3. Using the SQL Server Enterprise Manager or SQL Server Management Studio for SQL server, detach the database from the existing database server.
  4. Move the database files (both the database file (mdf) and the log file (ldf)) to the new location or new db 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. Using Infrastructure Manager, change the data_engine config to reference the new SQL server.
  7. Restart the robots on your primary server and UMP server.