SQL Server installations and databases
The management server, the event server, the log server, XProtect Incident Manager, and the Identity Provider store, among others, the system configuration, alarms, events, and log messages in the following SQL Server databases:
Surveillance
Surveillance_IDP: IDP
Surveillance_IM
The management server and the event server share the same SQL Server database while the log server, XProtect Incident Manager, and the Identity Provider each have their own SQL Server database. The default location of the databases is C:\Program Files\Microsoft SQL Server\MSSQL{nn}.MSSQLSERVER\MSSQL\DATA where {nn} is the SQL Server version.
The system installer includes Microsoft SQL Server Express, which is a free edition of SQL Server.
To see a list of supported SQL Server versions, go to https://www.milestonesys.com/systemrequirements/.
For more information about the Identity Provider, see Identity Provider.
For more information about the XProtect Incident Manager database and logging, see Logging and SQL Server databases.
For more information about the XProtect Incident Manager database and logging, see the separate administrator manual for XProtect Incident Manager.