Backup and restore

    Follow these 10 steps to backup and restore the database in ADAudit Plus.

    1. Stop ADAudit Plus, go to the Start menu > Services > Right-click the ADAudit Plus service, and select Stop.
    2. Go to <Installation-directory>\ManageEngine\ADAudit Plus\bin, open an elevated command prompt (right-click Command Prompt and select Run as administrator), and execute StartDB.bat.
    3. Execute BackupDB.bat.

      On executing BackupDB.bat, the back up file will be saved at the default location (<Installation-directory>\ManageEngine\ADAudit Plus\backup), under the default name (OfflineBackup_<timestamp>.ezip), with the default password (Backup@123$).

      Note 1 On executing BackupDB.bat, in addition to a timestamped .ezip file titled 'OfflineBackup_<timestamp>.ezip' getting created under <Installation-directory>\ManageEngine\ADAudit Plus\backup, a timestamped folder will also get created under <Installation-directory>\ManageEngine\ADAudit Plus\backup\EventData.

      Alternately, if you want to specify a location, name, and password for the back up file, execute BackupDB.bat BackupDirectory BackupFileName -p <password>.

      Here, BackupDirectory is the location where you want to save the back up file.
      BackupFileName is the name you want to provide for the back up file.
      -p <password> is the password you want to configure for the back up file.

      For example, if you want to save the back up file at E:\smith\backup, name the file as ADAPBackup, and configure the password as Pass@123$, execute BackupDB.bat E:\smith\backup ADAPBackup -p Pass@123$.

      Note 2 Ensure that you remember the configured password, without which the back up file cannot be recovered.

    4. Install a new instance of ADAudit Plus with the same build number as the old one. Start the new instance, go to the Start menu > Services > Right-click the ADAudit Plus service, and select Start. Now, stop the new instance, go to the Start menu > Services > Right-click the ADAudit Plus service, and select Stop.
    5. Go to <Installation-directory of old instance>\ManageEngine\ADAudit Plus, copy and paste the folder titled 'patch' to <Installation-directory of new instance>\ManageEngine\ADAudit Plus.
    6. Go to <Installation-directory of new instance>\ManageEngine\ADAudit Plus\bin, open an elevated Command Prompt (right-click Command Prompt and select Run as administrator), and execute RestoreDB.bat ZipFileLocation -p password.

      Here, ZipFileLocation is the location of the back up file.
      -p password is the password of the back up file.

      For example, in step 3, if you have saved the back up file at E:\smith\backup, named the file as ADAPBackup, and configured the password as Pass@123$, execute RestoreDB.bat E:\smith\backup\ADAPBackup -p Pass@123$.

      In step 3, if you did not specify a location, name, and password for the back up file and simply executed BackupDB.bat, execute RestoreDB.bat <Installation-directory>\ManageEngine\ADAudit Plus\backup\OfflineBackup_<timestamp>.ezip -p Backup@123$.

    7. Execute RestoreEventTables.bat FolderLocation.

      Here FolderLocation is the location of the folder mentioned in Note 1 under step 3.

      For example, in step 3, if you have saved the back up file at E:\smith\backup, execute RestoreEventTables.bat E:\smith\backup\EventData.

      In step 3, if you did not specify a location, name, and password for the back up file and simply executed BackupDB.bat, execute RestoreEventTables.bat <Installation-directory>\ManageEngine\ADAudit Plus\backup\EventData.

    8. Go to <Installation-directory of new instance>\ManageEngine\ADAudit Plus\conf, rename the customer-config.xml and database_params.conf files to any name.
    9. Go to <Installation-directory of old instance>\ManageEngine\ADAudit Plus\conf, copy and paste the customer-config.xml and database_params.conf files into <Installation-directory of new instance>\ManageEngine\ADAudit Plus\conf.
    10. Go to <Installation-directory of old instance>\ManageEngine\ADAudit Plus, copy and paste the apps folder into <Installation-directory of new instance>\ManageEngine\ADAudit Plus.
    11. Start ADAudit Plus, go to the Start menu > Services > Right-click the ADAudit Plus service, and select Start.