You would want to do some datemath depending on the current hour, and substitute the dates into the query.

So when current hour is 10, you want to do something like...

How are you doing the addition?  Via the GUI?

Could you script it instead using various ALTER AVAILABILITY GROUP commands to do the same and see if it's a GUI vs...

That's the way I would do it.

Set the new 2019 to ASYNC manual failover, so that things don't failover before you're ready.

Then when the time comes, set to sync, fail...

If the AG metadata is no longer present on a replica, then you need to destroy that AG and recreate it from the beginning.

The database “OptionsDBtemp” already exists on your server AND there is an open session in that database.

As someone / something is using that database while you attempt to restore it,...

Can't just set HADR back to ON if the replica is disconnected.

If you have no experience in AOAG's I wouldn't have put that technology in place for something as critical...

Check the Always On Health extended event files from all replicas, it should hopefully shine some insight as to what went on.

Going to hazard a guess someone set HADR OFF...

SQL 2012/2014 yes, you need a job to sort out the encryption keys on failover.

https://sqlrider.net/2021/05/automating-alwayson-availability-group-failover-for-ssisdb-2012-2014/

2016 onwards, once you have added the SSISDB to the AOAG ensure you enable the Always...

There is no UNC based access between the two machines?

\\ServerB\backups\copy

Like this?

OutOfMemoryException

Looks like you have a memory exhaustion issue.

What was the RAM using like at the time of the exception?  Maybe something you have running has a memory leak or a...

Yeah sorry it was the "Enable Always On Support for Integration Service Catalog" part of the document I was referring to, do you see these two jobs on each replica?

SSIS...

2017 right?

Did you enable the SSISDB AOAG support after the DB was added?

https://www.sqlshack.com/configure-integration-services-catalog-database-ssisdb-in-sql-server-always-on-availability-groups/

Did the failover/monitor jobs do anything weird, did they fail etc?

If its 2014/2012 then you need to have...

No you cannot get the true end users computer from profiler (or extended events for that matter) as that is not the computer connecting to SQL.

If you want to get...

First question about audits, is does the audit need to be legally binding for any compliance issues?

If yes - then SQL Audit is not the tool to use, you need...

The pit falls are having that many articles in a publication.

Depending on your setup it could and probably would cripple your system.

If you want a readable copy in Azure I...