Backup & Restore

Periodic backups are an essential part of running an information database software.
The backup process is described on this document in two levels: Local and External.

Automatic Local Backups (Snapshots)

SpeedBase automatically creates a backup of your database file on a daily basis. Backup files are also stored in the same data folder of your database. Daily backups protect your data from an unlucky database failure or loss of data due to accidental user action. They also help you to make some experimental changes on your database with confidence since you can quickly roll back your database to an earlier state if you are not satisfied with the result.

This type of backup is done silently in the background and you do not have to do anything about this process.

How to Take a Local Backup Manually?

Although SpeedBase takes daily database backups in the background, there might be cases when you need to backup the very last state of your database manually just before making some critical changes on your database or importing a large amount of data. To do this, open connection settings window from database menu and click "Backup Now" button.

How to Restore from a Local Backup?

You may return to an older state of your database. To do this, open connection settings window from database menu, select the backup file you wish to restore from the list and click "Restore" button.
Note that, once you restore from an older backup, you will lose all data created/updated after the creation time of backup to now.

Manual External Backups

There are several situations which happen rarely but having daily snapshot backups does not help (e.g. hard drive failures, virus attacks, fire, theft...). In order to minimize the damage in such conditions, you are recommended to take backups of your data folder to an external media within reasonable time intervals.

Since SpeedBase keeps all data under a single data folder, it is also the only folder which needs to be simply copied to some physically external media like a shared folder on your network, flash memory, cd, dropbox etc. You may manually copy the data folder to the backup media or, if you have a backup software, you can configure it to include your data folder as well during periodic backups.
To find out the location of your data folder, open connection settings from database menu. The path is displayed in the box labeled as local data folder location.

For maximum protection against viruses or other malicious software, you are recommended to use a backup media that is normally NOT connected to your computer between backup processes.

Beware that, SpeedBase only takes automatic backups on your local disk. You should remember to (externally) backup your data folder just as you do for other important files on your computer. SpeedBase however makes this easier for you by keeping all data under a single folder.

Backup to Cloud

To protect your data against physical threats, you may consider to use an online backup service like Dropbox or Google Drive. If you want to do so, remember that SpeedBase data folder should never be placed in a cloud backup folder. You may manually take a backup copy of your data folder and paste it into e.g. Dropbox folder.

How to Restore from an External Backup?

Remember that you are much more likely to find a recent local backup than an external one. So you are recommended to restore your database from a local backup as described above unless they are unavailable or damaged for some reason.

Follow the steps below to restore from an external backup:

Do not confuse the data folder ("data") with the database folder ("db").
The database folder is just one of the four subfolders found under the data folder and you should deal with (i.e. copy or move) the "data folder".

Online Help Home Page   ::   InfoLine Software Home Page