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 restore Wizard gives you the ability to configure possible database restore scenarios. You can:
Database Backup and Restore can be accessed through Tools menu.
To make Database Backup enter Database Backup/Restore Wizard:
4. On the next page you're able to preview it and in case you need a backup with some different settings - run the Wizard again.
To make Database Restore enter Database Backup/Restore Wizard:
3. Preview the script you wish to Restore from. Also there is a possibility to clear current database before restoring. Force Clear DB option excludes this possibility that some current database data not mentioned in the script stay as they are.
Attention! By clicking "Next >" Button you're starting restore from file selected before.
4. On the next page you're able to check all errors that 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.