Creating a database Backup

To create a database backup:

 1. Login to your SQL Server instance through SQL Server Management Studio.

 

 

2. Right-click on the specific database of your Bizagi project and select the Backup... option:


3. Specify that the backup type is set to FULL mode.


 

Notice that you need to select a valid path to store the resulting backup (.bak) file.
 
If you do not want to choose the default path, you may browse and select another file directory. If you choose a different location, ensure you have write access.

 

 

4.  Click on OK when the backup has executed completely.


Restoring a database

 

Performing the restore operation

 

Once you have ensured that the database is not in use, you may restore a backup:
 
 
 
1. Login to your SQL Server instance through SQL Server Management Studio.
2. Right-click on the specific database of your Bizagi project and select the Restore -> Database... option:



3.  Select that the database will be restored from a device. Browse and add your .bak backup file as the source media:





4. Check the Restore option for this media.

5. Go to the Options tab, and mark the Overwrite the existing database option.

6. Click on OK when the restore operation has executed completely.