Post reply

MSSQL Always On High Availability

  • November 28, 2017 at 9:38 am

    #330163

    We are testing a third party package and they want us to configure Always On. My question is in a test environment can we configure everything on one server?  By that I mean do I need an extra server for Windows Server Failover Clustering would like to do all on one server

  • November 28, 2017 at 9:56 am

    #1969756

    Short answer, no.

  • November 28, 2017 at 10:10 am

    #1969760

    rats was hoping for a yes but it is what it is
    thanks

  • November 29, 2017 at 1:09 am

    #1969836

    You could build a 1 node fail over cluster and install SQL as an instance, then create an availability group.

    Not true HA as its 1 node, but you can still configure AOAGs

  • November 29, 2017 at 9:13 am

    #1969935

    myukas - Tuesday, November 28, 2017 9:38 AM

    We are testing a third party package and they want us to configure Always On. My question is in a test environment can we configure everything on one server?  By that I mean do I need an extra server for Windows Server Failover Clustering would like to do all on one server

    AlwaysOn Failover Cluster Instance or AlwaysOn Availability Group?

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

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

Viewing 5 posts - 1 through 4 (of 4 total)

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