Loading ...
Loading ...
Loading ...
If you have a smaller setup and do not need scheduled backups, you can back up your system configuration
manually. For instructions, see Manually backing up your system configuration (explained) on page 318.
When you back up/restore your management server, make sure that the SQL database with the system
configuration is included in the backup/restore.
Requirements for using scheduled backup and restore
Microsoft® SQL Server Management Studio, a tool download-able for free from their website
(https://www.microsoft.com/downloads/).
Apart from managing SQL Servers and their databases, the tool includes some easy-to-use backup and
restoration features. Download and install the tool on your management server.
Back up system configuration with scheduled backup
1. From Windows' Start menu, launch Microsoft® SQL Server Management Studio.
2. When connecting, specify the name of the required SQL Server. Use the account under which you
created the SQL database.
1. Find the SQL database that contains your entire system configuration, including event server,
recording servers, cameras, inputs, outputs, users, rules, patrolling profiles, and more. The
default name of this SQL database is Surveillance.
2. Make a backup of the SQL database and make sure to:
l
Verify that the selected SQL database is the correct one
l
Verify that the backup type is full
l
Set the schedule for the recurrent backup. You can read more about scheduled and
automated backups on the Microsoft website (https://docs.microsoft.com/en-
us/sql/relational-databases/logs/the-transaction-log-sql-server?view=sql-server-2017
l
Verify that the suggested path is satisfactory or select alternative path
l
Select to verify backup when finished and to perform checksum before writing to
media
3. Follow the instructions in the tool to the end.
Also consider backing up the log server's SQL database with your logs by using the same method. The default
name for the log server's SQL database is SurveillanceLogServerV2.
Restore system configuration from a scheduled backup
Requirements
To prevent system configuration changes being made while you restore the system configuration SQL
database, stop the:
Administrator manual | XProtect® VMS 2023 R1
319 | Maintenance
Loading ...
Loading ...
Loading ...