New answers tagged

0

Availability Groups have rapidly become Microsoft's key HA strategy. They are slightly easier to setup and maintain than SQL Server Failover Clustering but provide slightly different benefits and drawbacks. FCIs are purely for SQL Instance level HA solutions whereas Availability Groups provide HA at the Availability Group (group of databases) level. They ...


-1

Why don't you use Database Mirroring instead and configure your applications to connect using a fail-over partner in the connection string (read more about that here Connect Clients to a Database Mirroring Session (SQL Server)). If you require automatic DBM fail-over then you will also need a Witness server (and run in-sync) in order to use High-Safety Mode ...



Top 50 recent answers are included