Guide to automate DataSecurity Plus database backup

You can now schedule your DataSecurity Plus database backup using a predefined script. Follow the steps below to set up a schedule for daily database backup using Windows Task Scheduler:

• Open Windows Task Scheduler.
• Click Action > Create task.
• Enter the Name and Description of the task (ex: DataSecurity Plus DB backup task).
• Retain or edit the service account that will be used to run the script.
• In Security options, select Run whether user is logged on or not and check the Do not store password option.
• Select Run with highest privileges.
• Choose the preferred operation system versions from the Configure for drop-down.
• Go to Triggers and click New in the bottom-left corner.
• Configure Begin the task as On a schedule.
• Under Settings, choose Daily and define the Start date and time.

Note: If scheduling daily backups, ensure you allocate sufficient storage space in the backup location drive. Alternatively, you can also schedule the backup to weekly or monthly as needed.

• Enter the Recur every value as 1.
• Click OK.
• Go to Action and click New in the bottom-left corner.
• Set Action as Start a Program.
• Under the Program/script field:
  • Use Browse to navigate to <installation_directory>\ManageEngine\DataSecurity Plus\bin.
  • Select the AutoBackupDB.bat and click Open.
• In the Start in field, enter <installation_directory>\ManageEngine\DataSecurity Plus\bin (do not enclose within double quotes).
• Click OK.

Note: The default location of the database backup is <installation_directory>\ManageEngine\DataSecurity Plus\Backup.

Note: When the specified service account is not the same as the current logged-in account, Windows Task Scheduler will prompt password authentication.

Follow the steps below to set or update a password for the task:

• In the Task Scheduler Library, right-click on the task created for automatic database backup and click Properties.
• Under Security options, click Change User or Group. Edit the service or user account. Click OK.
• Click OK on the task properties window.
• You will be prompted to enter the new password.
• Enter the Password and click OK.