That script snippet seems to update the wrong job.

The obfuscated name is larger than "DWLoad" for the job name in the job properties screenshot.

Are you sure you are comparing the...

They removed support for Oracle subscribers,

https://learn.microsoft.com/en-us/sql/relational-databases/replication/non-sql/non-sql-server-subscribers?view=sql-server-ver16

Anything after Oracle 12 doesn't work any more, you'll need to find a way to replicate the data another way, SSIS etc etc

Make sure you go through the Azure SQL VM checklist to get the best bang for your buck on what you’re paying out for.

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-checklist?view=azuresql

If you know how to unpick everything and what data to delete from all the tables to ensure the data is as it should be at the point in time...

TRNs only as good as an older FULL

Without a FULL to start the chain then all subsequent logs are useless.

So based on that picture and to get it to 8am on the 8/4/2022

Restore the 11:00pm full with no recovery

Restore the 6am diff with no recovery

Restore the 6:30/7/7:30 logs with...

So how do you get the BAK file from the original server?

Are you manually going making a backup, then moving it as part of your process?

Can the original server automatically...

Makes sense, the DB needs to undergo the upgrade process from a 2014 format to a 2022 format and if it's read only the upgrade process can't write the changes.

I...

There can be, you need to understand what hardware you have, and what the disk specs are.

Data files are random IO based patterns, where are Log files are sequential IO...

Did you read the documentation?

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-scale-availability-groups?view=sql-server-ver16

More specifically this section

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-scale-availability-groups?view=sql-server-ver16#connect-to-read-only-secondary-replicas

You can connect to read-only secondary replicas in either of two ways:

Applications can connect directly to the SQL Server...

Create 2 FCI's one in each DC, then link them both with a AG.

You get local automatic failover should a local host fail, and you get manual failover to DR...

Legacy there means your drivers.

If your driver doesn't support MSNF then set it to false if you are in a multi subnet setup.

But if your driver does support it leave...

Run the select without the insert, what type of values are you getting for what would be inserted into STRIKE_CONTRIBUTION?

Is anything in double digits, 99.9999999999999999

If so your numeric(28,27) is invalid...

CNAME to the Listener, no need for Failover Partner anymore.

There could be a whole host of reasons as to the login failure, not limited to, but

You're on a multi subnet...

Also remember, increasing your CPU increases your license cost, so ensure you have the licenses available before you just go increasing CPUs, otherwise you'll be in for a nasty shock...