Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

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

11 April,19 at 11:51 AM

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.

 

Attachments:

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.