SQL Server and Fail-over rights RRS feed

  • Question

  • I have a question about SQL Server Fail-over rights.   The Product Terms do not cover the technical implementation for passive failover rights.  I need a SQL Server technical resource that can provide the best guidance for which activities would be considered "passive" or fall under Fail-over rights.  Specifically what does Microsoft allow a customer to do with a passive server when exercising their Fail-over Right? 

    In the past (before mirroring was deprecated) Microsoft used to tell customers there were three things they could do between the active and passive server; log shipping, mirroring, and fail-over clustering.

    Now that Mirroring has been deprecated and replaced in SQL Server Standard by Basic Always On Availability Groups and considering that feature is not available in SQL Server Enterprise (which includes Always On Availability Groups what activities are currently allowed under Fail-over Rights for SQL Server and are they different between the Standard and Enterprise editions?

    For instance, can a customer setup always on to do a passive failover (using either Basic Always On Availability Groups, or Always On Availability Groups depending on the edition of SQL used), and would that implementation from a technical perspective be covered under Fail-over rights?

    Friday, July 12, 2019 8:38 PM

All replies