Database Backup for MS SQL

Access Manager Plus (AMP) allows you to schedule tasks to back up the database contents periodically as well as take an instant backup of your data. For MS SQL, the backup will be stored as a .zip file by default in the host, where the SQL server is running. All the sensitive data will remain encrypted in that file.

This document helps you understand two types of Database Backup in detail:

  1. Scheduled Backup
  2. Instant Backup

1. Scheduled Backup

This type of backup allows you to schedule the database backup to be executed at any specific point of time.

  1. Navigate to Admin >> Configuration >> Database Backup.
  2. In the pop-up window that appears, select the schedule option - day, weekly or monthly.
  3. Select the time frequency (dd:hh:mm) at which the backup has to occur.
  4. The Destination Directory field shows the default directory path: <AMP_installation_directory>/backUp. You can change the path, if required.
  5. Every time backup is executed according to schedule, a backup file will be created in the destination directory. Specify the maximum number of latest backup files to be stored in the directory. For example, if you choose "10" from the drop-down Maintain latest, only the latest 10 backup files will be stored in the directory.
  6. Click Save. The backup schedule is now created.

2. Instant Backup

    1. Navigate to Admin >> Configuration >> Database Backup.

    2. Click the Backup Now button.

    This option will trigger an immediate database backup task. Check the status in the Audit >> Task Audit section. The backup file will be stored in the destination path as a .zip file.
Top