SQL Servers and databases (explained)

The management server, the event server and the log server store, for example, the system configuration, alarms, events and log messages in SQL databases on one or more SQL Server installations. The management server and the event server share the same SQL database while the log server, XProtect Incident Manager, and the Identity Provider each have their own SQL database. For more information about the Identity Provider, see Identity Provider (explained). For more information about the XProtect Incident Manager SQL database and logging, see Logging and SQL databases.

The system installer includes Microsoft SQL Server Express which is a free edition of SQL Server.

For very large systems or systems with many transactions to and from the SQL databases, Milestone recommends that you use a Microsoft® SQL Server® Standard or Microsoft® SQL Server® Enterprise edition of the SQL Server on a dedicated computer on the network and on a dedicated hard disk drive that is not used for other purposes. Installing the SQL Server on its own drive improves the entire system performance.