Back Up Files Containing Audit Trail Data on SQL Server - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Hexagon

1. On your target Windows server, select a disk drive with 300 MB free disk space for the storage of about 1 million records.

2. Create a folder INtoolStorage.

3. Do one of the following:

   • On the SQL Server with a Smart Instrumentation database created in a default instance, create the following path: <drive>:\INtoolStorage\<default instance name of the new SQL Server server>\<Smart Instrumentation database name>.

     For example: e:\INtoolStorage\Develop2\SPI_1 - where the default instance name Develop2 corresponds to your target Windows server name.

   • On the SQL Server with a Smart Instrumentation database created in a named instance, create the following path: <drive>:\INtoolStorage\<new SQL Server name>\<named instance name of the new SQL Server>\<Smart Instrumentation database name>.

     For example: e:\INtoolStorage\Develop2\SPI2009\SPI_1 - where the new SQL Server name Develop2 corresponds to your target Windows server name.

4. Do one of the following:

   • When using SQL Server with a Smart Instrumentation database created in a default instance, copy the content of the folder SPI_1 in the source path e:\INtoolStorage\Develop1\ to the folder SPI_2 in the target path e:\INtoolStorage\Develop2\.

   • When using SQL Server with a Smart Instrumentation database created in a named instance, copy the content of the folder SPI_1 in the source path e:\INtoolStorage\Develop1\SPI2009 to the folder SPI_2 in the target path e:\INtoolStorage\Develop2\SPI2009.

5. Restart your computer.

See Also

Managing Audit Trail Data