• TheSQLGuru (11/14/2013)


    Please don't just read a few blog posts, run a few forum questions and then set off doing AGs!!! NOTHING good will come of that! This is complex stuff with lots of caveats, provisos and gotchas!

    I get the feeling that its a bit of a rushed out product, I have been evaluating AG's for the last 2 months and there are a number of issues I have found so far. Specifically replication. Your distribution database cannot be part of an availability group meaning really you need to host it in a seperate SQL instance and possibly used clustering to provide any sort of HA. Although there is the option to utilities 2 or more of your servers used as part of the AG solution to host an additional clustered instance with shared storage.

    Subscribers are not particularly well supported either and a real pain to deal with if part of a AG.

    MCITP SQL 2005, MCSA SQL 2012