9. Tools‎ > ‎

1. Database Backup/Restore

Maintaining a backup, and, or, restore of your Store Database, is not only a good practice but a real necessity. Backing up the database allows for recovery of lost, or corrupted data, either partially, or totally, in the case of an operating system, software, or hardware failure. It also offers a level of protection for problems due to human mistakes, that can damage, or make the database inoperative, and the data inaccessible.
The backup and recovery Wizard provides facilities for configuring a number of possible database restore scenarios.
Using the Restore Wizard, you may:

- Backup the current Store database,
- Restore over the current database,
- Backup multiple databases.

Database Backup and Restore is accessed through the Tools menu.

1. Database Backup

To perform a Database Backup, open the Database Backup/Restore Wizard:
1. Select Backup current store database.

2. Specify a filename to which to save your DB backup.

3. Select the tables that you wish to backup. If you have chosen Backup entire database, all tables would be checked. In addition, you may manually check, or uncheck them. Subsequently, you may Restore from backup, or Restore default database with initial data, to restore your data to a stable, prior state.

It is also a possible to save only the database structure (tables with no data). You may also select Copy, Create Statements, and the underlying SQL statements will be saved within the backup file.
Important!: Clicking the 'Next >' button, will save the script into the previously selected file.

4. The subsequent page will present an opportunity to preview your changes. If it is necessary to create a backup with different settings, the Wizard may be run again.

finish database backup

2. Database Restore

To Restore a Database, start the 'Database Backup/Restore' Wizard:
1. Select the 'Restore over current database' option, 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. Also, the current database may be cleared, before restoring. 

The 'Force Clear DB, before executing' option precludes the possibility that some current database data, not mentioned in the script, might stays as is.

 By clicking the 'Next >' Button, you will be starting 'Restore', from the prior file selected.

4. On the following page, you will be able to check, and review, any errors that may have occurred, during script extraction.

After a database is restored, from a backup file, it will only allow users to access the data that was available, prior to the time that the backup file was created. Any, and all, database changes, made from subsequent points, are lost.

 thaBy eMagicOne Inc.