I'm always ranting at the TV about backups too, Gary :-D.

I have always wondered...

I know, at pretty much every session there are two talks I want to go to simultaneously!

😀 Yeah, I think non-DBAs would definitely say that about us. I might see you at Inside SQL then,...

tindog (4/27/2016)

---

I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know anyone! (Never been to Liverpool)

I'll have to...

? You don't have to have a listener to connect to either a primary OR a secondary.

The listener (rather than the primary) directs read-intent...

You're right, you can only fail over to two nodes automatically.

No, a secondary can "receive connections" if it's set up to be readable, but obviously they will be read-only. (There...

In 2014 you can have 3 (including the current primary), I think. Try it (if it's not in Production).

Yes, it means the AG won't fail over to R3 currently. If you change it to automatic failover, it should.

It's hard to know without seeing your connection string. Does it work when you connect to the listener through SSMS with the AD credentials?

Bump in case anybody in the States is online and might know.

Thanks.

Check this out as well:

https://www.brentozar.com/archive/2013/07/announcing-our-free-accidental-dba-6-month-training-plan/

Thanks, both. I've got it working now.

I also found a blog post that helped me find where to get some of the data from:

http://www.sqlphilosopher.com/wp/2012/08/a-few-changes-in-sql-server-2012-dbcc-loginfo-and-dbcc-checkdb/

Thanks for the replies. The default is a good idea, but it's still failing in 2008 R2 with Msg 213, Level 16, State 7, Line 1

Column name or number of...