High availability of the SQL Server databases

The XProtect services store data in different SQL Server databases:

• Surveillance for the Management Server and Event Server services

• Surveillance_IDP for the Identity Provider

• Surveillance_IM for XProtect Incident Manager

• LogserverV2: LogServer for the lLog Server service.

To provide redundancy for the SQL Server databases, you must ensure that the services and components can access their databases. Depending on your needs, you can consider different high-availability options:

Always On availability groups

Always On availability groups (AGs) help protect databases by keeping copies of the databases on other hosts, called replicas, which can take over if the primary host fails.

To learn more about AGs, see What is an Always On availability group?

Failover cluster instances

Failover Cluster Instances (FCIs) provide high availability for the entire SQL Server instance, ensuring that all components, including databases and jobs, move to another host if a failure occurs.

To learn more about FCIs, see Always On failover cluster instances (SQL Server).

Log shipping

With SQL Server Log shipping, you can copy the transaction log file from one SQL Server instance to another.

To learn more about log shipping, see About log shipping (SQL Server).