Automatic database backup

AD360 can automatically back up its database and the databases used in the integrated products at regular intervals, as scheduled by you. Using this option, you can back up the built-in PostgreSQL DB or external PostgreSQL and MS SQL databases configured in the product.

Supported DB versions for auto backup

Prerequisite for backing up external PostgreSQL

  1. In the machine where PostgreSQL is installed, go to <postgresql_installdir>/data and open the posgresql.conf file. Search for wal_level entry. Uncomment the entry and change its value to archive.
  2. Copy all the files in <postgresql_installdir>/lib and <postgresql_installdir>/bin folders and paste them in <product_home>/pgsql/lib and <product_home>/pgsql/bin folders respectively. <product_home> refers to the home directory of AD360 or the integrated products for which you're configuring the auto backup scheduler.
  3. Restart the external PostgreSQL server.
  4. Repeat the steps 1 to 3 from above whenever you update the PostgreSQL server.

Steps to schedule database backup

  1. Navigate to Admin → General Settings → Database Settings → Database Backup.
  2. Choose AD360 or an integrated product for which you want to schedule auto backup, and click the edit icon.
  3. Select whether you want to schedule the backup daily, weekly, or monthly and at what time from the Backup Frequency drop-down.
  4. Enter the number of incremental backups to take for every full backup in the Full Backup after __ incremental backups box. Enter 0 if you want to take only full backups.
  5. Enter the Backup Storage Path.
  6. Note 1: If the shared folder is located in a workgroup computer, then create a new domain account in AD. This new account should have the same username and password as that of a local account in the workgroup computer. Use the credentials of this new account for authentication.

    Note 2: If the specified path is wrong or unreachable, the backup will be stored in the default backup folder (<Installation_Folder\Backup>).

  7. Set a retention period for the backup files from the Maintain Backup Files drop-down.
  8. Click Save.

Other settings

Restoring backup from an old version of MS SQL server to new MS SQL server

If you've installed a new version of MS SQL server and want to configure it in AD360 or its integrated products in place of the old MS SQL server, you can do so by using the backup you've taken using AD360. Just note that, in addition to the backup you've taken using AD360, you need to copy the files in <MS_SQL_Old_Version>/Backup to <MS_SQL_New_Version>/backup.

Troubleshooting tips

If you get an error while backing up the database, please check whether: