Post reply

SQL Server 2012 AlwaysOn

  • March 27, 2014 at 4:41 am

    #283942

    Hi Guys,

    Need your advise here.

    Anyone did such setup with AlwaysOn Avail Group?

    We are looking into using AlwaysOn Avail Group for the purpose of HA.

    Server A: Instance A with (DB1,DB2,DB3,DB4,DB5)

    Server B: Instance B with (DB6,DB7,DB8,DB9,DB10)

    We are trying to implement in such a way that Server A makes use of Server B for redundancy and vice versa.

    thanks

  • March 27, 2014 at 5:07 am

    #1700626

    Pl. refer following article for further detail:

    http://qa.sqlservercentral.com/articles/FCI/92196/

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • March 27, 2014 at 6:06 am

    #1700640

    chewychewy (3/27/2014)

    Hi Guys,

    Need your advise here.

    Anyone did such setup with AlwaysOn Avail Group?

    We are looking into using AlwaysOn Avail Group for the purpose of HA.

    Server A: Instance A with (DB1,DB2,DB3,DB4,DB5)

    Server B: Instance B with (DB6,DB7,DB8,DB9,DB10)

    We are trying to implement in such a way that Server A makes use of Server B for redundancy and vice versa.

    thanks

    If I understand it correctly you have 2 servers with 1 instance each?

    For the scenario above you'll likely end up with 2 AlwaysOn groups for the 2 sets of databases.

    Are both nodes on the same site?

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

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

  • March 27, 2014 at 6:49 am

    #1700658

    Hi Perry,

    Yes u are right. Both servers on same site (using vm).

    Appreciate your help!

    Is such setup recommended and possible? Thanks

  • March 27, 2014 at 7:23 am

    #1700668

    Essentially the databases DB1,DB2,DB3,DB4,DB5 would be primary on Server A in an AlwaysOn group with secondary as Server B

    The databases DB6,DB7,DB8,DB9,DB10 would be Primary on Server B with secondary as Server A.

    This would allow the 2 database groups to be placed where required

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

    "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