What type of database does the pi system uses?

What type of datbase does the PI system uses?

Parents
  • I find this question also very relevant, may it be a proprietary one, it is important to know where persistent our data resides for backup & restore reasons

  • ​ ,

    If you're interested in where your PI Point/Tag data exists for backup and restore purposes, the data is within the archive files on the Data Archive node.

     

    Archive files contain the events, timestamps along with the corresponding tag's PointID and Record Number so that it can match the correct data to the correct tag.

     

    As for backups in our PI Data Archive Backup Best Practices, we always recommend a 2 step backup. Where the first step is backing up the PI Data Archive using our pibackup process with a scheduled task, and then use a 3rd party utility (or if need be the pisitebackup script) to move a copy of the backup to another location such as a network drive or external drive.

     

    Note: to restore the data you not only need the archive files but also the non archive files that are backed up by the pibackup subsystem, since those contain the PI Point configuration information to allow a PI Data Archive to match the data in the archive files to the correct PI Points.

     

    Asset Framework stores the hierarchy information, analyses, and notification information within a SQL database that is configured on installation that is by default named PIFD. We also recommend regular scheduled backups of the PIFD as well. How to perform a full backup of the PI AF SQL database

Reply
  • ​ ,

    If you're interested in where your PI Point/Tag data exists for backup and restore purposes, the data is within the archive files on the Data Archive node.

     

    Archive files contain the events, timestamps along with the corresponding tag's PointID and Record Number so that it can match the correct data to the correct tag.

     

    As for backups in our PI Data Archive Backup Best Practices, we always recommend a 2 step backup. Where the first step is backing up the PI Data Archive using our pibackup process with a scheduled task, and then use a 3rd party utility (or if need be the pisitebackup script) to move a copy of the backup to another location such as a network drive or external drive.

     

    Note: to restore the data you not only need the archive files but also the non archive files that are backed up by the pibackup subsystem, since those contain the PI Point configuration information to allow a PI Data Archive to match the data in the archive files to the correct PI Points.

     

    Asset Framework stores the hierarchy information, analyses, and notification information within a SQL database that is configured on installation that is by default named PIFD. We also recommend regular scheduled backups of the PIFD as well. How to perform a full backup of the PI AF SQL database

Children
No Data