As of version 1.0.8.1877, dbFront automatically creates a backup of the configuration with every change. These backups are automatically maintained and purged.
As of version 1.2.4.1767, you can simply restore to a previous backup from within the database preferences. Simply open the database preferences and click on Configuration Backups.
Manually Restoring a Backup
If you are using a dbFront version prior to 1.2.4.1767, or if you need to manually restore a whole server the please read below.
Although the config backups happen automatically, at the moment, the restore process is complex.
To recover one of these backups you need to find the correct configuration backup file and restore it.
The default location for all of the dbFront configuration and backups is [C:\Data\dbFront\Data\].
Within this folder you will find one or more folders with names like "7b7b8114868d4b5694ac3cb3c9d4b4a0". Each one of these folders represents a single database connection.
Within each database connection folder you will find a "Backups" folder containing the backup files for the databases available to that connection. The backup files will have names like "AdventureWorksLT_20191024_153329.713.jsonData".
The backup filename begins with the name of the database followed by the date and time of the backup.
To restore a backup you will need to copy the file to the folder [C:\Data\dbFront\Export].
Once the backup file has been copied to the folder [C:\Data\dbFront\Export], then you will be able to select and restore it from within dbFront.
To restore a backup do the following:
- Login to dbFront with Admin privileges,
- Switch to the "Advanced View",
- Select the connection for which you want to restore the configuration.
- Click on the "Import" button,
- Select the database who's configuration you want to restore,
- Select the backup file you previously copied to the [C:\Data\dbFront\Export] folder.
Config backup files will not contain any data so the restore process should be very quick.
