2. Automated Backup

fmAddSchedulerTaskfmBackupRestoreWizardOutgoing Email!fmAddNewSQLDialog

Backup helps you to keep your store data in safety and prevent its possible loss or damage as a result of some operations.

Automated Backup and Script Execution options allow to perform database backup and run SQL script according to the schedule configured in advance.

It helps to make copies of the store data in a certain period and keep your data from failure.

Automated Backup

Backups tab

In order to configure Automated Backup of a database in the first time, press [Create or Modify Configuration] and launch the simple backup process (see the point about this here).

Automated backup - Create & Modify option

In the last step save configuration by clicking the relevant button, as shown on the illustration below.

Save backup configuration in Options step

If there is a previously saved configuration you can, in the "Backups" tab, select it from the drop-down list and click [Run Backup] button to launch the process.

Run Backup

This process takes some time. You will see the notification at the bottom of the window:

Backup was successfully created

Now you can add backup to the scheduler, using the corresponding button on the toolbar.

Please note, to be able to perform that you should have the administrative rights in Store Manager. In the timeline form choose the specific period: weekly, daily, monthly, yearly or at once; set the operation time; the day of the week or specific month.

Add current backup to scheduler

If necessary, at the bottom of the form select the fields on task repetition. Choose the position the most suitable for your needs.

Repeat task

Click on the [OK] to save all settings and start the schedule.

Script Execution tab

In case you need to run SQL scripts frequently, Automated Script Executions option will be useful for you.

Create or Modify Script button

Specify SQL script file in the proper field of the wizard.

Load settings in SQL Script File step

The next window displays the SQL script of the executable file. Press [Next] button to continue.

If you intend to only restore files, select the relevant field.

Save script file

Save the current configuration in the corresponding field at the bottom of this window.

Click [Save] button to start the execution of the SQL script file, which you specified on the first step of the Wizard.

Run Script button

- run script with the current configuration.

NOTE!: Do not run Script, in case you are not sure that SQL is working properly and will not corrupt your database.

Add current script to scheduler

- serves as task name, time and frequency specification.

Use the other options in the top toolbar to perform the following operations:

Refresh button

- update data in the current page.

restore button

- restore over current database.

Delete button

- remove selected backups or script executions from the list.

Preview button

- preview backup data or script execution details.

Open folder

- open the folder, where the file with data is located.

Scheduled task list is the list of tasks that is stored in your Window scheduler. To open it go to Addons / Scheduler Options section and choose [Show Scheduled Tasks].

Show Scheduled Tasks

There you can find your task to backup your database along with other window tasks performed regularly. Via scheduled tasks’ toolbar you can add new tasks or remove existing ones, launch selected task, view the properties of the task, enable/disable the task execution.

Show Scheduled Tasks toolbar