Back up the runtime database

We recommend that you back up all AVEVA Historian and SQL databases:

• Before you make any changes to the database, in case you want to return to the original configuration.

• On a regular schedule, to minimize data loss in the event of a disk failure. The best way to perform database backups is to set up automatic backups using SQL Server Management Studio. You should back up your database at least once a week.

When you perform a database backup, all system tables, user-defined objects, and data are copied to a separate file located on a backup device. Backup devices include disk files, floppy diskettes, zip disks, and tape drives. Backups can be easily managed using the SQL Server Management Studio.

You should not back up the current history block unless you are using a VSS-aware backup utility.

The primary and msdb databases should be on the same backup schedule as the Runtime database.