Automatic Database Backup

What is Automatic Database Backup?

Starting from the 4.0 release, Nx Witness creates backup files automatically without the user’s involvement on a weekly basis. Once installed, the Server application will check for a backup file and, if none are found, it will immediately create one.

The Server application will create weekly backups of the System’s database until there are 6 backups are made.  Once the number of backups reaches 6, the oldest backup will be deleted, and a new one will be generated. 

Before creating a backup file, the Server application will also ensure that there is enough space on the system drive -- at least 10 GB of free space will be required. This rule is applied only for the cycling mechanism. There will always be at least one backup file.

How to restore from a Backup:

1. In the Desktop client from the Main Menu ( ≡ ) select System Administration.
2. In the General tab click on the Restore from Backup button. 
3. Locate the desired backup file in the relevant folders. By default the paths are:
   
   • It will have the following file format: esc_<build_number>_<time_stamp>.db
   • In Windows the .db file can be found here: 

      C:\Windows\System32\config\systemprofile\AppData\Local\Network Optix\Network Optix Media Server\backup\

   • In Linux the .db file can be found here: 

      /opt/networkoptix/mediaserver/var/backup/

4. You will be prompted if you want to restore the database. Click Ok to restore the database.
5. The database will be restored (this should be quick, but it may take some time depending on the size of the database). 
6. Once restored, a dialog with the message “Database successfully restored” will open.
7. The server application will be restarted automatically. 
8. Click Ok to close the dialog.
9. Click Ok to close the System Administration menu.

Questions

If you have any questions related to this topic, or you want to share your experience with other community members or our team, please visit and engage in our support community or reach out to your local reseller.