afbackup​.bat

The pibackup.bat script calls afbackup.bat, if it exists. Since afbackup.bat is part of the AF SQL database scripts, it exists on the Data Archive computer only if the AF SQL database scripts is installed on the same computer as Data Archive. The afbackup.bat script is installed in the pipc directory under pipc\AF\sql.

By default, the afbackup.bat script backs up an instance of SQL Server called ./sqlexpress. If the PI AF database is called sqlexpress and is located on the Data Archive computer, then the scheduled backup task backs up that database. The PI AF database backup is written to:

pibackupdir\AF\

where pibackupdir is the backup directory passed to the pibackup.bat script.

You can edit the afbackup.bat file to back up a different SQL Server instance, such as sqlserver. The afbackup.bat script is a site-specific file. If you upgrade Data Archive, this file is not overwritten.