BackupRestore Blindata database¶

Backup Database

There are two ways to backup the Blindata database.

1. The first way is to save the backup file manually via the Administration > Backup DataBase routine.
Execute button on this form allows selecting the path where the database should be stored.

When you click Execute button a confirmation message appears asking if you want to remain on the existing path or amend it.
By selecting the Cancel button it is possible to determine another path where backup can be saved and specify its name.
The backup name in that case should contain a file extension .bak (like on the example below).

But please note that the manual backup file can only be saved on the local drives of the server and cannot be saved on the client’s PC.

2. The second way is to carry out an automated backup of the Blindata database.
The settings can be found in Administration > Parameters > Automated Tasks>Automated Backup.
So you can specify the name of the backup file, the periodicity of the backup in days, and the start time of the backup operation.
Also, note that the path and folder should be placed on the local drive of the server.
The periodicity of the backup in days can be set in the ‘Each Day’ field and this cannot be set up as zero.

So when the backup is saved by Automatic Backup for the first time it creates the backup file in the specified folder.
Then each time when the Automatic Backup runs it resaves the existing automated backup file in this folder.
In case the path or name is changed in Backup Path then an absolutely new automated backup file will be stored.
The automated backup functionality will only work properly if SQLSERVERAGENT service is running on the server; otherwise, the automated backup task won’t be started.
Please note that it is important to have 'Microsoft SQL Server Standard Edition' version to be able to use this functionality.

Restore Database

In order to restore the backup, you should use the Administration > Restore DataBase routine.
Using the drop down list you may select the backup which should be restored.

The list contains the backups which were created either automatically or manually.
The manual backup file will be called ‘Blindata_exact date_exact time’ (as in the example above).
The backup stored via Automated Tasks is called as ‘AutoBackupBlindata’ (without date and time) and it always contains the last backup stored through the Automatic Backup routine.
‘Delete Backup File’ button allows removing the backup from SQL SERVER Objects.