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 Managing server services)
• Event Server service (can be done from Windows Services (search for services.msc on 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 (https://technet.microsoft.com/library/cc732317(WS.10).aspx/)

Open Microsoft® SQL Server Management Studio from Windows' Start menu.

In the tool do the following:

1. When connecting, specify the name of your SQL Server. Use the user account under which the SQL Server database was created.
2. 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.
3. 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
4. Follow the instructions in the tool to the end.

Use the same method to restore the SQL Server database of the log server with your logs. The default name for the SQL Server database of the log server is SurveillanceLogServerV2.

The system does not work while the Management Server service is stopped. It is important to remember to start all the services again once you have finished restoring the database.