SQL high Availability (Cluster or AlwaysOn )

  • Hi!
    I need to install SQL server 2016 HA
    I installed two w2016 servers with shared storage and install both sql server in cluster, but now I don't know if it's better do it with always ON and standalone sql server?

    Someone can show me in this cases I need to user SQL clustering or Sql Always on?

    Thanks a lot

  • omoyanogo - Wednesday, February 21, 2018 8:54 AM

    ...but now I don't know if it's better do it with always ON and standalone sql server?...

    Check this article, it will answer most of your questions - https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server

  • omoyanogo - Wednesday, February 21, 2018 8:54 AM

    Hi!
    I need to install SQL server 2016 HA
    I installed two w2016 servers with shared storage and install both sql server in cluster, but now I don't know if it's better do it with always ON and standalone sql server?

    Someone can show me in this cases I need to user SQL clustering or Sql Always on?

    Thanks a lot

    Please read my stairway to AlwaysOn, starting at the following link

    http://www.sqlservercentral.com/stairway/112556/

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

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

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

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