Skip to main content

OEM PI Server

The PI data used in Sigmafine is normally obtained from a production PI Server, which should have its own backup procedure. In this section, the backup procedure of the OEM PI Server is described.

Note: We recommend that you run the backup procedure on a daily basis.

Setting up Automatic Backups​

In order to automatically execute an OEM PI Server backup, create a scheduled task with the PI\adm\pibackup.bat backup script.

The following is the syntax to perform a backup and create the scheduled task.

PIbackup.bat \<path\> [number of archives] [archive cutoff date] [-install]

  • The <path> requires the full path for the location of the PI OEM Server backup.
  • The additional parameters are optional. They correspond to the number of archives to backup and the cutoff date for the backup.
  • The –install parameter indicates that it is a scheduled task. If the –install parameter is not specified, the backup is performed immediately. The backup should be checked daily, ensuring that the message log shows the last backup as 'completed successfully'.

If a SQL Express version of the SQL Server is used, the 'pibackup.bat' script also calls the 'afbackup.bat' script. The 'afbackup.bat' script makes a backup of the following databases: PIFD.bak, Master.bak, and Msdb.bak. The 'Master.bak' is the SQL Server master system database. It contains metadata about all SQL databases and global configurations, such as log ins. If SQL Server has a complete failure, a copy of this file is required. The 'Msdb.bak' is the SQL Server msdb system database. It contains scheduled job information for the SQL agent along with other various data.