Understand PI AF collective - SQL Server backups

We strongly recommend that you make regular backups of SQL Server data, especially on the primary server. The PI AF installation process creates a SQL Server backup job that is scheduled to run by SQL Server Agent. Make sure you copy these backups to media other than the media that contains the data.

If you accidentally delete data on the primary, the deletions will be replicated to the secondary. The only way to recover accidentally deleted data is from backup.

For detailed information about backup strategies for replicated databases, see the Microsoft article Strategies for Backing Up and Restoring Snapshot and Transactional Replication.

For more information about backing up the PI AF SQL database, see PI AF backup considerations.