Restore system configuration from a scheduled backup
Requirements
To prevent configuration changes being made while you restore the system configuration database, stop the:
- Management Server service
- 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.
Open Microsoft® SQL Server Management Studio from Windows' Start menu.
In the tool do the following:
- When connecting, specify the name of the required SQL Server. Use the account under which the database was created.
- Find the Surveillance database that contains your entire system configuration, including event server, recording servers, cameras, inputs, outputs, users, rules, patrolling profiles, etc.
- Make a restore of the Surveillance database and make sure to:
- Select to back up from device
- Select backup media type file
- Find and select your backup file Surveillance.bak
- Select to overwrite the existing database.
- Follow the instructions in the tool to the end.
If you also backed up the SurveillanceLog database from the old log server, restore it on the new log server by using the same method.
Note that the system does not work while the Management Server service is stopped. It is important to remember to start the services again once you have finished restoring the database.
© 2018 Milestone Systems A/S