Tools‎ > ‎

2. Automated Backup


fmAutoBackupRestore, fmAddSchedulerTask, fmAddSchedulerTask, fmWindowsTaskList



Backups help ensure, that your files aren't permanently lost or damaged. With automatic backups, you don't have to remember to backup your database.


‘Automated Backup’ or ‘Script Execution’ tool helps you to backup your database or run  SQL script according to the scheduler to save your time and protect your database from failure.



Automated Backup


Automated backup

Use this settings toolbar to perform following operations:


Backups toolbar

Click “Create or Modify Import Configuration” button Create and Modify Configuration  to run Backup Wizard and configure settings ;


Run backup with current configuration button - run backup with current configuration;

- add backup to the scheduler with current configuration:

Add current Backup to Scheduler


In order to add scheduled task, you should have administrative privileges. 


Click on "Add Current Backup to Scheduler" button to specify the task name, time and frequency.

You can choose to backup database Daily, Weekly, Monthly or once.

Daily - If you wish to backup your database daily, specify start time and frequency.

Weekly - If you wish to backup your database weekly, specify the time, the day of a week and frequency.


Monthly - If you wish to backup your database monthly, check/uncheck month(s), when you wish to import products, day and start time.


Once - You can backup your database only once when it's more comfortable for you.


Show scheduled Tasks - show scheduled  tasks list. Scheduled task list is a list of tasks stored in your Windows scheduler. 

You can call it, using Addons -> Show Scheduled Tasks

Show scheduled tasks


Here you can find your task to backup your database along with other windows tasks performed regularly.

Here you can add or delete the task, see properties, refresh list and run a task.   


Tasks toolbar


Refresh button -  refresh data.
 
Restore over current backup- restore over the current database.

Delete selected backup- delete selected backup.

Preview backup- click here to preview backup data.

Open folder- open the folder, where this file is located.

Adjust auto width- using these buttons you can adjust columns width or set columns auto width. 


Script Execution


In case you need to run  SQL scripts frequently, Automated Script Execution tool will be a great solution for you!


Script executions


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


In this section you can find Automated Script Execution settings, which allows you to perform following operations:


Click “Create or Modify Import Configuration” button to run Wizard and configure settings  Create or Modify Script Configuration;


run Script -  run script with the current configuration.

Add current Script- Click on "Add Current Script Execution to Scheduler" button to specify the task name, time and frequency.


Show scheduled tasks- show scheduled  tasks list. Scheduled task list is a list of tasks stored in your Windows scheduler. You can call it, using Addons -> Show Scheduled Tasks. Here you can find your task to backup your database 

along with other windows, tasks performed regularly.

Here you can add or delete the task, see properties, refresh list and run a task.    


Scheduled lists toolbar


You can use the same buttons as in automated backup procedure (refresh, delete, restore etc).


By eMagicOne Inc.

Comments