Maintaining a backup and restore of your Store Database is not only a good practice but a real necessity. Backing up the database allows recovery of the database either partially or totally in case of an operating system, software, hardware failure, or human mistakes. These can damage or make the database inoperative and the data inaccessible.
The backup and recovery Wizard gives you the ability to configure possible database restore scenarios.
Database Backup and Restore can be accessed in the "Tools" tab.
To make Database Backup start Database Backup/Restore Wizard:
Important! To avoid issues with the database, we strongly recommend using Direct connection to the database to perform the backup/restore operations.
1. Select "Backup current store database" to perform.
2. Specify a file for your database backup to be saved in.
3. Select the tables you wish to backup. If you choose to backup entire database, all tables would be selected, but you can select or unselect them all by yourself.
Restore from backup or Restore default database with initial data.
Using top toolbar you can manage data you want to backup.
"Select all" allows to choose all data from your database for backup.
"Clear Selection" cancels your previous selection.
"Invert Selection " means to transform specified selection on the opposite.
"Preset" - pre-set filter for data backup. You can choose from the drop-down list necessary selection or create your own filter for data backup, using this button:
In the field, which appears, specify the required filter's parameters and click the [OK] button. To launch filter click the [Use Preset] button.
This button serves to remove filter parameter if you want.
4. There is also a possibility to save only database structure (tables with no data).
You have an opportunity to save backup settings in the backup wizard directly or to a separate file, by selecting the relevant action when you press [Save Settings] button.
Keep in mind, that the second variant to complete the procedure of backup will need some time.
Please also note, that the first option makes it impossible further database restoration.
To start backup process press [Backup] button.
5. On the next page, you're able to preview the result of the backup procedure.
To make Database Restore start Database Backup/Restore Wizard:
1. Select [Restore over current database] and press [Next] to proceed.
2. Specify a file for your database backup to be Restored from.
3. Preview the script you wish to Restore from.
Attention! By clicking the [Next] button you're starting the restore from the file selected before.
4. On this step you can choose the option to restore files.
Earlier, there was a possibility to clear the current database before restoring - "Force clear database before executing", now this option is not added
You can also save restore configuration in a .cfg file or in backup/restore wizard directly, using [Save Settings] button.
5. On the final step, you're able to check the result of restore procedure and all errors occurred during script extraction.
After the database is restored from a backup image, it will only allow users to access the data available at the time the backup image was taken.
All the database changes made from that point on are lost.
Multiple Database Backup
To make backup for multiple stores simultaneously start Database Backup/Restore Wizard:
1. Launch Backup/Restore Wizard and choose from the "Welcome" page the required operation.
2. Specify a target directory, where the file will be placed and check the appropriate stores, which databases will be duplicated.
Please note, that pressing the [Backup] button you're keeping all actions in the directory you have selected above.
To start the process click [Backup] button.
3. Next page allows you to preview all details of multiple backups and see the results.
Clicking [Finish] to complete the work in the Wizard.