Description

Resolution

Steps to backup the database:

1. Start the Command Prompt as an administrator (right-click Command Prompt and select Run as Administrator).
   
2. Navigate to <Installation_Dir>\bin (By default: C:\ManageEngine\ADSelfService Plus\bin) folder by using the cd command.
   
3. Now, execute the command backupDB.bat to backup the database.
   
4. A folder named Backup will be created in the ADSelfService Plus installation directory (By default: C:\ManageEngine\ADSelfService Plus\Backup) and it will contain the DB back-up in compressed file format (eg: 081224-1547.zip).
   

Steps to restore the database:

1. Start the Command Prompt as an administrator (right-click Command Prompt and select 'Run as Administrator')
   
2. Navigate to <Installation_Dir>\bin (By default: C:\ManageEngine\ADSelfService Plus\bin) folder by using the cd command
   
3. Now, execute the following command to restore the database from the backup:
   

restoreDB.bat compressed_file_name.zip -p <password>

E.g.:restoreDB.bat 081224-1547.zip -p <password>

The password for the database backup file could be one of two types:

1. Default password: This is the reverse string of the filename. For the filename mentioned above, the password would be "7451-422180".
   
2. Admin-configured password: This is the custom password that was configured in the admin portal before creating the database backup. The Change Password For Database Backup Files option under Admin → Connection → General Settings is used for this.