How to manually backup and restore the database in ADSelfService Plus?
Description
You can manually backup and restore the database in ADSelfService Plus by executing certain commands.
Resolution
Steps to backup the database:
- Start the Command Prompt as an administrator (right-click Command Prompt and select Run as Administrator).
- Navigate to <Installation_Dir>\bin (By default: C:\ManageEngine\ADSelfService Plus\bin) folder by using the cd command.
- Now, execute the command backupDB.bat to backup the database.
- 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:
- Start the Command Prompt as an administrator (right-click Command Prompt and select 'Run as Administrator')
- Navigate to <Installation_Dir>\bin (By default: C:\ManageEngine\ADSelfService Plus\bin) folder by using the cd command
- 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:
- Default password: This is the reverse string of the filename. For the filename mentioned above, the password would be "7451-422180".
- 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.
If you have forgotten the password to the backup file, but have access to the ADSelfService Plus installation directory, the encrypted password can be obtained from the customer-config.xml file (<installation_dir>\conf\customer-config.xml), and you can contact support@adselfserviceplus.com to decrypt it. If not, the backup will be inaccessible and a new backup will have to be created.
New to ADSelfService Plus?
Related Articles
Automatically backup the ADSelfService Plus database
Description The database used in ADSelfService Plus houses some important information that is crucial for the proper functioning of the tool. As a proactive measure against the loss of data, the ADSelfService Plus application provides you Automatic ...How to migrate the ADSelfService Plus installation from one machine to another
Description This article will guide you through the process for migrating the ADSelfService Plus installation from one machine to another. Important: Before you start the migration process, please update your ADSelfService Plus installation to the ...Migrating from ADSelfService Plus 32-bit to ADSelfService Plus 64-bit
This article will help you migrate from ADSelfService Plus 32-bit version to the 64-bit version. Before you begin 32-bit to 64-bit migration is possible only between the same builds. For example, you cannot migrate from a 32-bit version of build 5310 ...Encryption and data storage in ADSelfService Plus database
Encryption in the ADSelfService Plus database ADSelfService Plus' database uses the following encryption methods to store sensitive data: Database Encryption method PostgreSQL AES-256-CBC Microsoft SQL AES-256-CBC The following sensitive information ...ADSelfService Plus product startup issues
What do you need to know before troubleshooting You need to have administrator access to ADSelfService Plus. When you experience an error with ADSelfService Plus, check if these prerequisites are satisfied: Install ADSelfService Plus as a service ...