Back Up Files Containing 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
  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