I'm thinking I either need to recreate the AG on Node 2.  Or bring Node 1 up as the primary somehow.  Yikes, this isn't a nice issue.

Can't delete but I've answered my own question.  Should have researched more before posting.

My 2 x Synchronous databases were not in sync.  Once this was resolved, growth occurred.

Genius, I can do it via a job.  Thanks!  I'm the only real admin & talking anyone else through it will be a pain.  Only issue now is that it's...

Great, thanks!  That does the trick perfectly.

Not to worry, I'm interested in the answer but I guess I can do this with charindex ... I'll give it a go.

Fair question.  Good point made.  Thanks

So I have an AOAG set up.  I'm not keen to go for it.  Duplication isn't really an issue - (don't ask! there are lots of constraints here).

I'm presuming it's...

Oosh, my mistake.  It was a SQL cluster with a virtual SQL server name.  I'll leave it here in case there are any other stressed out dummies.  Thanks for answering...

2016 SP2.

Duh, of course.  Thanks Jeff!  Appreciate you taking the time to reply.  I work alone and every now and again, just get stuck on something and it REALLY helps to...

Thanks Brian.  Appreciate the response.  Some good ideas I'll have a deeper look into.  I especially like the pushing to both systems - sorting it out at source but if...

Hi Brian,

Thanks for taking the time to answer.  You raise some really good points.  I guess I was thinking from my side as the DBA that I suspect there's a...

Duh.  So it WAS me being a div.  I hadn't clocked that Alejandro.  Many thanks.

Hi again,

Just a quick note to say that it seems you can failover an AlwaysOnAG role via the FCM if it is set to synchronous with auto failover.  You can't...

Hey Jeffrey, thanks for the reply.

So I've just checked on my estate & I am able to failover the AlwaysOnAG via the FCM for the other clusters.  Right click, move...