What do you mean by that? AOAGs rely on an underlying Windows Server Failover Cluster, but that doesn't mean...

Eric M Russell (10/16/2015)

---

As for the option of sticking around and "fixing" your current job, unless you're in a position of influence, I find that ideal outcome to be...

What happened when you ran the Cluster Validation Wizard? If you haven't run it, run it :-D.

Yep- I was just covering all bases because the original post isn't all that clear.

Obviously you need to contact your licensing vendor for the definitive statement on your situation, but do be aware that if you plan to run any kind of DBCC command...

Can't you just delete the listener through the GUI and re-create it?

Are you using the 2012 or the 2008 R2 Configuration Manager? Check you're not using the 2008 R2 one, because they can't always "see" newer versions.

Yes.

Did you do a dbcc inputbuffer(spidnumbergoeshere)? Or a DBCC OPENTRAN? Sorry if I'm stating the obvious.

If replication is coming from the primary and you lose the primary, replication will break.

Are you connecting with the actual server name & instance name, rather than with a port number or something like that? It sounds as though you are from what you...

Telling us the exact error message would be a good start.

It's fairly straightforward, but obviously you should test it somewhere first that isn't Production.

I think since you're already paying for Enterprise Edition, and you have enough servers, you might as well give it a try. Since you'll be using aysnchronous availability mode, there's...

Does this apply?

If any column that is part of a unique constraint is updated, then SQL Server implements the update as a "deferred update", which means as a pair of...