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.