Data-Backup

You can execute the scripts BackupPGSQLDB.bat/.shandRestorePGSQLDB.bat/.sh to take a backup of and restore the data.

  • You can find the BackupPGSQLDB.bat/.sh under <Applications Manager Home/bin>.

  • To back up data, execute the following commands in the command prompt:

    BackupPGSQLDB.bat/.sh

    the output (back up data) would be put under <working/backup/backupzip_date_time>

    for eg.,
    /<working/backup/backupzip_Jan_3_2008_14_51_15/backupzip_Jan_3_2008_14_51_15.zip>/

  • To restore the backup data, Execute the following command in command prompt

    RestorePGSQLDB.bat/.sh <Absolute path of the zip file that was backed up on executing BackupDB script >

    For eg.,  RestorePGSQLDB.bat/.sh"C:\AppManager_Home\working\backup\backupzip_Jan_3_2008_14_51_15\backupzip_Jan_3_2008_14_51_15.zip"

While restoring backup, Applications Manager and Applications Manager's PostgreSQLDB should not be running.

Configuring a backup task:

You can configure a backup task with Task Scheduler as follows:

Program/Scripts : <AppManager_Home>\bin\BackupPGSQLDB.bat

Start In: <AppManager>\bin\

  • Configure the triggers and other information in the Task Scheduler. Please make sure you choose the option "Run whether the User is Logged On or Not" so that the Task runs irrespective of the fact that the user is logged on or not.

  • In the Actions, please configure it as follows

Program/Scripts : <AppManager_Home>\bin\BackupPGSQLDB.bat

Start In: <AppManager>\bin\

  • Then save the task and test it to know if it works.

For Microsoft SQL Server backend:
  • For Database Backup: Connect to the SQL Management Studio tool & backup the complete AMDB database. Click here to know how to backup SQL database.
  • For Database Restore: Connect to SQL Management Studio tool & restore the complete AMDB database backup. Click here to know how to restore the SQL database backup.
Applications Manager should not be running during database restore. Refer the below link for more detailed information about SQL database backup & restore steps: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases
Note: Users should not use the SQL Server Import and Export Wizard to perform backup or restore of Applications Manager database.