• AlexSQLForums - Tuesday, January 2, 2018 2:25 PM

    Is each AG in synchronous mode in the same Data Center and asynchronous mode for DR?

    Is this what you want, it all depends on your requirements

    AlexSQLForums - Tuesday, January 2, 2018 2:25 PM


    VM's or physical? Hyper-V or VMware?

    What's your requirement here?

    AlexSQLForums - Tuesday, January 2, 2018 2:25 PM


    What kind of storage are you using?

    all depends on the above, physical or virtual

    AlexSQLForums - Tuesday, January 2, 2018 2:25 PM


    How are your disks setup per box?

    as above

    AlexSQLForums - Tuesday, January 2, 2018 2:25 PM


    Are all data/log files on the same drive but different folders?

    see above

    AlexSQLForums - Tuesday, January 2, 2018 2:25 PM


    Are there listeners setup? if yes which ports are you using for each listener?

    do you require read only routing?
    If so, which port do you want to use, using 1433 is the best option

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

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