Configure Auto Backup properties for the Batch Historian database

Note

For MSSQLServer and SQLServerAgent services to access remote machines to perform backups, the service accounts must be modified with the Service Control Manager. The destination (where the backup will be written) must be a shared device and the MSSQL services logon account must have Change permission to the destination folder.

  1. Select MaintenanceAutoBackup.
  2. Select the Properties tab.
  3. Check Enable backup.
  4. Choose the frequency (in days) and time to perform the backups.
  5. Enter a backup filename. The name will be incremented as follows:

    MainBackup_1_DVHisDB.bak

    MainBackup_2_DVHisDB.bak

    MainBackup_3_DVHisDB.bak

    (where MainBackup is the backup filename as configured).

  6. Select the backup destination directory. You can find the directory by clicking the Browse... button.
    Note

    Because of the operating system security restrictions, the destination path cannot entered as a mapped drive. Instead, enter the destination as a UNC path (\\machinename\sharename\folder). This is also the case when browsing for the destination. Replace any mapped drive destinations with the appropriate UNC path.

  7. Choose the number of completed backups to keep in the directory before reusing the filename.
    Note

    The system keeps n completed backup copies (where n is the number of completed backups designated by the user). The system also keeps one additional backup as the working file. The working file is the file the next backup process will overwrite. Therefore, if the backup process fails, there are still n good backups.

  8. Click OK or select the Status tab.