Backing Up Audit Trail Data on SQL Server - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Hexagon PPM

Intergraph Smart Instrumentation Administration

Language
English (United States)
Product
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version
13.1

The software allows you to back up the files containing trimmed audit trail data for SQL Server database server in your Windows environment.

The file with the audit trail data is a .txt file that appears on your Windows server in a path that depends on your SQL Server version as follows:

  • When using a SQL Server with a Smart Instrumentation database created in a default instance, the system creates the file in the following path: <drive>:\INtoolStorage\>default instance name>\<Smart Instrumentation database name>

    For example: e:\INtoolStorage\Develop1\INtools1 - where the default instance name Develop1 corresponds to your source Windows server name.

  • When using a SQL Server with a Smart Instrumentation database created in a named instance, the system creates the file in the following path: <drive>:\INtoolStorage\<SQL Server name>\<named instance name>\<Smart Instrumentation database name>

    For example: e:\INtoolStorage\Develop1\INtools53\INtools1, where the SQL Server name Develop1 corresponds to your source Windows server name.

To enable loading of the audit trail data after moving a Smart Instrumentation database from one SQL Server database to another, you must make a backup of the .txt files with the trimmed audit trail data on your Windows server.

See Also

Managing Audit Trail Data