License Backup

If you would like to re-use your BioStar 2 license, refer to the following article: [BioStar 2] Reactivating the License


Backup Instructions

You can back up the BioStar database on Microsoft SQL Server Management Studio Express.
You can download it at http://www.microsoft.com/en-US/download/details.aspx?id=8961


1. Connect to your database server.
 


2. Find the BioStar database and right-click it. Choose Task > Back up….
 


3. Click OK to complete the backup process.
 



Additional Backup Items


2.6 Database Encryption Key Backup (mandatory)

For BioStar 2.6 you must also back up the encryption key file located in C:\Program Files\BioStar 2(x64)\util


Configuration

If you are going to restore the server in a different PC, you will have to back up the configuration files which hold the cloud and server settings. 

Back up the setting.conf and system.conf files in C:\Program Files\BioStar 2(x64)


Image Log Backup (optional)

If you want to back up the image log images, you will have to back up the imagelog folder in the BioStar 2 directory. 

C:\Program Files\BioStar 2(x64)\


Paste it to the same directory after restoring the database. 


Note: The image logs that are stored in this folder are the image logs that you have clicked to check in the monitoring menu. Not all logs are saved in this folder by design to help with BioStar 2 performance


Video Database Backup

BioStar 2 video integration was introduced for MSSQL in BioStar 2.6. 

Back up the video database and also the back up the files in the folders  below: 


C:\Program Files\BioStar 2(x64)\ve\records

C:\Program Files\BioStar 2(x64)\ve\db\


 




Restoration Instructions

You can restore a BioStar database backup on Microsoft SQL Server Management Studio. 

1. Connect to your database server.
 


2. Expand the Databases item in Object Explorer to see if there is an existing BioStar database. If you want to delete the existing database, right-click the item and choose Delete. 

Note: You must stop the BioStar server before deleting the BioStar database.

 

3. Click OK to complete the database deletion process.


4. Right-click the Databases item in Object Explorer and choose Restore Database….
 


5. Enter BioStar in the To database field and choose the From device option and click the box on the right side of the option in the Source for restore section.
 


6. Click Add and locate the database backup you want to restore. Then, click OK.
 
 
 


7. Set the checkbox on the Restore column in the Select the backup sets to restore: section.


8. Click OK to restore the database backup. 


9. If it fails, go to the Options page and check if the information for the database backup is correct. Mostly, the cause of the failure is due to a mismatch of folders between a backup PC and a target PC. 

You can change the target folder from the Restore the database files as: section.



Additional Restoration Items


2.6 Database Encryption Key Restore (mandatory)

For BioStar 2.6 you must also restore the encryption key file in C:\Program Files\BioStar 2(x64)\util

This must be restored before you start the BioStar services. 



Configuration

If you are restoring your server in a new PC and not a existing BioStar 2 install, restore the server configuration as below. 

Open the setting.conf and system.conf files you backed up from C:\Program Files\BioStar 2(x64)

Paste the relevant configuration contents to the setting.conf and system.conf files in C:\Program Files\BioStar 2(x64)


Caution: Note that the items port (https server port) and ssl_address (server IP) in the setting.conf should be configured according to the new server's IP and BioStar Setting configuration.




Image Log Backup (optional)

Restore your imagelog folder in C:\Program Files\BioStar 2(x64)\


Video Database Restore

Restore the video database and restore the following folders that you have backed up 


C:\Program Files\BioStar 2(x64)\ve\records

C:\Program Files\BioStar 2(x64)\ve\db\