Microsoft SQL Server Brings High Availability to Public Safety Solutions

When seconds count, having a computer-aided dispatch and incident management system with high availability is critical to providing first responders the data and information they need to be on site as quickly as possible.

Pairing our Intergraph Computer Aided Dispatch (I/CAD), the industry’s leading incident management software suite, with Microsoft SQL Server can create a high-availability solution that mitigate the effects of system issues, ensuring the availability of applications and minimizing user downtime.  Microsoft SQL Server high-availability capabilities are not limited to I/CAD. It can also be used with InPursuit WebRMS, our premier suite of records management software for police and law enforcement agencies, as well as our public safety analytics solutions.

Leveraging Microsoft SQL Server 2016 provides several options that can enhance high availability for the databases you will use to power your I/CAD, InPursuit WebRMS, or analytics solutions. Microsoft SQL Server high-availability options include:

Always On Failover Cluster Instances
Always On Failover Cluster Instances leverages Windows Server Failover Clustering (WSFC) functionality to provide local high availability through redundancy at the server-instance level—a failover cluster instance (FCI). On your network, an FCI appears to be an instance of SQL Server running on a single computer, but the FCI provides failover from one WSFC node to another if the current node becomes unavailable.

Always On Availability Groups
Always On Availability Groups is an enterprise-level high-availability and disaster recovery solution that enables you to maximize availability for one or more user databases. Always On Availability Groups requires that the SQL Server instances reside on Windows Server Failover Clustering (WSFC) nodes.

Log Shipping
Like Always On Availability Groups and database mirroring, log shipping operates at the database level. You can use log shipping to maintain one or more warm standby databases (referred to as secondary databases) for a single production database that is referred to as the primary database.

If you would like to know more about how Microsoft SQL Server Always On Technology enhances high availability for our I/CAD, InPursuit WebRMS, and analytics solutions, register for our upcoming webcast: “Responding to Public Safety Challenges”.

  • Want Safer Cities?

    Subscribe to CONNECT to receive inspiration, ideas, and expert how-to advice for creating safer, more resilient cities – delivered right to your inbox.


  • Serving our industries and communities

    A library of educational resources, inspirational stories and support services in response to the global COVID-19 crisis.

  • Recent Posts

    More