how to migrate databases associated with a Centrify DirectManage Audit 3.x installation

how to migrate databases associated with a Centrify DirectManage Audit 3.x installation

By Centrify on ‎06-30-2018 05:55 PM

A DirectManage Audit 3.x installation typically creates and deals with two types of databases i.e. an Audit Server database (also known as the Management database) and Audit Store database. The Audit Server database stores DirectManage Audit 3.x application specific settings whereas the Audit Store database is used to store the actual audited user sessions. A typical DirectManage Audit 3.x installation consists of one Audit Server database and one or more Audit Store database(s).

 

In a nutshell, here are the steps involved when migrating database from one database server to another:

 

Step 1  - Stop all the collectors

 

Step 2  - Take backup of existing databases (optional but recommended)

 

Step 3 -  Detach the existing databases and attach them to the new database server

 

Step 4  -  Ensure that CLR integration is enabled on the new database server and login for NT AUTHORITY\SYSTEM exists on the server

 

Step 5  -  Restore the TRUSTWORTHY flag and owner of the database

 

Step 6  - Modify the newly attached Audit Server database

 

Step 7 -  Restoring connection between Audit Server database and Audit Store database

 

Step 8  -  Update the database entries in Active Directory

 

Step 9  -  Start all the collectors

 

Attached document explains in details each step above should be taken in case if database migration is inevitable in order to keep the impact on the DirectManage Audit system as minimal as possible.

 

Showing results for 
Search instead for 
Do you mean 
Labels

Community Control Panel