Post reply

SQL Cluster 2012 AlwaysOn-Two Secondary Replicas

  • April 14, 2014 at 1:23 am

    #306474

    Dear Gurus,

    I need your kind support for the below query.

    while configuring SQL Server 2012 Cluster with Always on, why do we need two secondary replicas.

    The attached link will describe the actual query.

    http://i61.tinypic.com/4j2pw8.png

    Regards,

    Sheeraz

  • April 14, 2014 at 10:10 am

    #1705819

    I don't click links like that, sorry. But a) what are you trying to accomplish and b) what error are you getting exactly?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • April 14, 2014 at 11:41 am

    #1705862

    Sheeraz

    You can achieve a supported Quorum for a pair of SQL servers with a File Share Witness. As such one Primary Replica and only one Secondary Replica can exist.

    /Colin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply