Restore system configuration from a scheduled backup
Requirements
To prevent system configuration changes being made while you restore the system configuration database, stop the:
Management Server service (see Restore system configuration from a scheduled backup)
Event Server service (can be done from Windows Services. Search for
services.mscon your machine. Within Services, locate Milestone XProtect Event Server)World Wide Web Publishing Service, also known as the Internet Information Service (IIS). Learn how to stop the IIS (Microsoft website)
From Windows' Start menu, open Microsoft® SQL Server Management Studio,
In the tool, do the following:
When connecting, specify the name of your SQL Server. Use the user account under which the SQL Server database was created.
Find the SQL Server database (the default name is Surveillance) that contains your entire system configuration, including event server, recording servers, cameras, inputs, outputs, users, rules, patrolling profiles, etc.
Make a restore of the SQL Server database and make sure to:
Select to back up from device
Select backup media type file
Find and select your backup file (.bak)
Select to overwrite the existing database
Follow the instructions in the tool to the end.
Note
The system does not work while the Management Server service is stopped. It is important to remember to start all the services again after you have finished restoring the database.