Backing up and Archiving Data - PAS ICS Integrity - 7.3 - Help - Intergraph

ICS Integrity Help

Language
English
Product
PAS ICS Integrity
Subproduct
ICS
Search by Category
Help
PAS Version
7.3

Microsoft SQL Server database backup and restore operations are used to recover from catastrophic hardware or software failure. These operations run against the entire database and are not recommended for simple archival purposes. Microsoft SQL Server includes database maintenance tools that you can use to back up and restore Microsoft SQL Server databases. When backing up your data, review the following considerations:

  • The default database name is Integrity. Periodically store a backup copy of the database in a secure location.

  • In some deployment scenarios, you may want to configure Integrity to work with multiple databases. In these cases, be sure to back up all your databases. For more information, see Working with Multiple Databases for Enterprise Deployments.

  • If you enable asset roll back, Integrity creates an additional database with the same name as the Integrity database prefixed with Rollback_, such as Rollback_Integrity. Make sure you also back up this database.

  • If you enable event log data collection, Integrity creates an additional database named PASWindowsEventLogs. Make sure you also back up this database.

Integrity provides several features to help you archive or save data. These features can help you recover from incorrect data collected from one or more systems. You can choose to implement and use any or all of these features:

Asset Roll Back

This feature allows you to roll back the data for an asset to a previously imported set of data in the event that the most recently imported data is old, invalid, or corrupted. For more information, see Understanding and Enabling Asset Roll Back.

Data Archive

This feature allows you to archive the latest data files for an asset following each import for that asset. You can also restore the latest archived data files. These files are stored in a separate location that you specify. For more information, see Understanding Import Data Archives.

Data Forwarding

This feature securely exports and transports data for a set of objects from one Integrity site to another Integrity site where it can be imported. For more information, see Understanding Data Forwarding and Receiving.