Backup Restore Blindata database using SQL Management Studio¶
Open Microsoft SQL Management Studio then connect to your server, right-click the database and select 'Tasks > Back Up' as shown below:
Open 'General' tab, select the path where backup will be saved and create a name for a database backup, please note that it is important to add .bak to the name, for example, BlindataTest01122020.bak:
Create a backup:
To restore the database, please right-click the 'Databases' and select 'Restore Database' as shown below:
Select a backup file:
Please note that if the backup is not visible - it means you forgot to add .bak to the backup's name, in this case, you need to select from the dropdown file type all files.
The database will be restored under the original name, but if you need to change it - then please change it here:
And make sure the path is correct.
If you need to restore the database files to a specific folder you can change the path to it here:
If the database is restored on a new server, then please contact Blindata support, since it is necessary to make additional changes to the SQL server and Windows settings.