Scheduled backup and restore of system configuration (explained)

The management server stores your system's configuration in a SQL Server database. Milestone recommends that you regularly make scheduled backups of this database as a disaster recovery measure. While it is rare to lose your system configuration, it can happen under unfortunate circumstances. Luckily, it takes only a minute, and backups also have the added benefit that they flush the transaction log of the SQL Server database.

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).

When you back up/restore your management server, make sure that the SQL Server 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/en-us/sql-server/sql-server-downloads).

Apart from managing SQL Server and its databases, the tool includes some easy-to-use backup and restoration features. Download and install the tool on your management server.