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.
The backup and restore Wizard gives you the ability to configure possible database restore scenarios. You can:
- Backup current store database,
- Restore over current database,
- Backup multiple databases.
Database Backup and Restore can be accessed through Tools menu.
1. Database Backup
To make Database Backup start Database Backup/Restore Wizard:
1. Select Backup entire current database to perform.
2. Specify a file for your DB backup to be saved in.
3. Select the tables you wish to backup. In this case when you have
chosen Backup entire database all tables would be checked, but you can
check or uncheck them all by yourself. Restore from backup or Restore
default database with initial data.
There is also a possibility to save only database structure (tables
with no data). If you wish to select Copy Create Statements, such SQL
statements will be saved in the backup file.
Attention! By clicking "Next >" Button you're saving the script into the file selected before.
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.
2. Database Restore
To make Database Restore start Database Backup/Restore Wizard:
1. Select Restore over current database option and press Next to proceed.
2. Specify a file for your DB backup to be Restored from.
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 stays as is.
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 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.
