Thank you, Sue. I did Google but wasn't using the right terms obviously. I'll try some of those suggestions.

Sounds like it's below your skillset, Jason.

Sorry to ask, but is anybody here able to help me with my Availability Group puzzler here please?

Yes. Right-click on tempdb > Properties > Files > Initial Size.

It caught me out the other day; I even uninstalled it and reinstalled it- doh.

Is your Reporting Services configured to point to an Availability Group listener or just an instance?

With Reporting Services and AlwaysOn Availability Groups, it's not as simple as just...

Ah, wait; you want AvailabilityGroup1 as primary on SQL01 and AvailabilityGroup2 as Primary on SQL02? You can do that, yes.

Assuming this is a SQL login, did you create it with the same SID on both instances?

You don't have to use a listener at all, but in your scenario I'd change the DNS entry so that the alias points to the listener anyway. Then if you...

Does it actually fail over (i.e. does another replica take on the Primary role) or is it just a brief blip?

Anything in the cluster event log at around...

The copy-only full backups won't make any difference because full backups don't truncate the transaction log anyway. As anthony says, check that your log backups aren't copy-only.

What's the...

No, that's not possible.

Why would you want to do that?

I really agree with Phil there. $100 extra per month for that is exploitation. Whether or not you decide to change careers, you should at least consider moving somewhere where...

Do you yourself have sufficient permissions?

Yeah, you have to do this sometimes. I have both SSMS 2017 and SSMS 2016 on some boxes because it turns out 2017 can't see SSIS 2016. A while back...

Me again; I think I've figured it out so I thought I'd post it here in case anybody else has the same issue. Basically it worked fine if I saved...