AnzioBake (2/5/2016)

---

It seems My original post was deleted.

To curious_sqldba: All criteria listed in your blog has been met ( barring using ONE Ad account for all instances).

The...

Entire purpose of AAAG is to have high availability. You can fail over your AG to another node, patch primary , fail back to primary once patching is done and...

I guess i am not clear on your question. If you need on daily basis can u just set up a scheduled daily backup job?

pawana.paul (2/2/2016)

---

All,

We have 2 node cluster in data center A where we configured AlwaysOn. In data center B we have SQL Instance which will be DR for databases of data...

Practically you could...

Backup /restore?

There have been many many discussions on this website on this topic. Most recent one is here http://www.sqlservercentral.com/Forums/Topic1744971-2799-1.aspx#bm1745147

GilaMonster (2/2/2016)

---

Replication has a 2-version limit....

Perry Whittle (2/1/2016)

---

curious_sqldba (2/1/2016)

---

If you are moving to 2016, it will be two phase migration, from 2008R2 - > 2014 and then from 2014 -> 2016. At most you upgrade...

tcronin 95651 (2/2/2016)

---

it looks like I can have 2014 with an AG read only node, however been overruled that vmotion will be failover, can't win that one. I believe...

Can you please update the link?

If you are moving to 2016, it will be two phase migration, from 2008R2 - > 2014 and then from 2014 -> 2016. At most you upgrade to 2 versions.

TheSQLGuru (1/28/2016)

---

curious_sqldba (1/28/2016)

---

I am big fan of Ola's script too, the only problem is it doesn't create multiple jobs. I used his script for DBCC but i had to...

I am big fan of Ola's script too, the only problem is it doesn't create multiple jobs. I used his script for DBCC but i had to make quite...

We just installed Biztalk 2013 (not 2013 R2), we did not make it as part of AAG because it is not compatible.