• Pablo Campanini-336244 (8/28/2014)


    1.- Can I set up Always-On in both servers?. and have 1 or 2 databases with Always-on?

    No, requires a Windows Server Failover Cluster

    Pablo Campanini-336244 (8/28/2014)


    2.- Does Always on uses the "endpoints" as Mirroring?

    Yes, AlwaysOn uses the traditional database mirroring endpoints for instance to instance communication. However, the WSFC handles the AlwaysOn cluster resource and moves\updates it as necessary, usually on failover.

    Pablo Campanini-336244 (8/28/2014)


    Kevin, also thanks for responding, but can you also address the 2 above questions please?.

    At this point, I am installing SQL 2012 on 2 different windows servers (NO CLUSTERING involved here), just plain and simple.

    Your only options at this point are mirroring, log shipping, replication

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉