How to Backup and Restore a Database

How to Backup and Restore a Database

This instructional video will show you how easy it is to back up and restore your database.

Backing up your database will store all the information from the database in a file that can be transferred to different locations and restored later. To make a backup of your database, go to the File drop down menu. From here go to ‘Backup and Restore’ and click on ‘Backup Database’.

On the pop-up window that appears, click Next an explorer window will appear. This will allow you to choose where you want to make the database backup. Once you choose the location to save your backup, click ‘Save’. This will begin the database backup process. A pop-up will appear once the backup is done; click ‘OK’ to complete the backup process. Make sure to not close the software until this is completed.

The software is also configured to make automatic backups. To configure the settings of these backups, first go to the File drop down menu. From here go to ‘Backup and Restore’ and click on ‘Automatic Backup Settings’. You can click on the ‘Enable Automatic Backup’ checkbox to toggle the automatic backup feature. There are also settings to choose how many automatic backups to keep along with when and how often to make these automatic backups.

Lastly, you can change the location of where these automatic backups are made. Click on ‘Select’ to choose a new location to make the auto-backups. Once you choose the new location, click on ‘OK’ to save it. You can click on ‘Explore’ to go to the current automatic backup location. Clicking on ‘Default’ reverts the auto-backup location back to the default location. Click ‘OK’ to save changes to the automatic backup settings. It is still recommended that you make backups manually.

Restoring your database will restore all the data that is contained in the database backup. If you already have a database loaded, restoring a backup will erase the contents of the current database and replace it with what is contained in the backup. To restore a database backup, go to the File drop down menu. From here go to ‘Backup and Restore’ and click on ‘Restore Database’. On the screen that appears, click on the ‘Restore Database from Backup’ button. On the prompt, click ‘Yes’.

You are given three options for restoring a backup. The first option will automatically restore the newest recorded automatic backup. Clicking ‘Next’ would begin the restore process.

The second option will allow you to either restore a backup from a specific location, or will allow you to choose from a list recorded automatic backups. This is the option that would be used if you are restoring the database on a new computer.

If you choose to restore from a specific location, clicking ‘Next’ will bring up an explorer window where you can navigate to the location of the backup. Once the backup is selected, click ‘Open’ to begin the restore process.

If you choose to restore from the automatic backup location, clicking ‘Next’ will bring up a list all recorded automatic database backups. Select a backup and then click ‘Restore’ to begin the restore process.

The last option allows you to restore your database using an SQL database file. This option is only recommended for advanced users and should only be used when it is not possible to restore from a database backup. During the restore process it may prompt you to close the software on all client computers. If you are using a network version of the software, make sure to close the software on all other computers before clicking ‘OK’. On the next prompt, click ‘Yes’. Now your database will be restored from a backup. A prompt will appear once it has been restored. Make sure not to close the software until you have closed this prompt.