What are you seeing in the logs?

Do you see a lot of IO Frozen / IO Resumed messaged when the backup is “running”?

You may be facing slow VSS rather than...

Generally this all starts from the IIS side, what credentials are the app pools running as?

I suggest you read the SQLCMD documentation again.

If ds.user is a login then you have to use -U and the same -P for the password.

-u and -p have totally different...

Do you need to do this via ADO / LDAP queries?

My preferred method would be to combine the AD PowerShell module with DBATools and then use things like Get-ADUser from...

Thank you for the article.

Can I ask: when you day: Enter port number 1433, and enter the IP address for your listener.  This should be an unused IP address...

Again Mirroring requires connection string changes to add in the FailoverPartner parameter.

Simply just changing a server to be "Server A" isn't just a simple thing in SQL and when invoking...

So the issue you have is DNS / connection strings.

What do YOU want to happen in a DR situation?

When you invoke DR do you want to go and change all...

This is for disaster recovery only, so we can have some down time and do manual failover.

Yes it is in another location.

Currently we have the SQL server running standalone...

Transactional replication would be a no as replication isn’t tracking update statistics operations.  All that cares about is insert/update/delete statements.

The indexes on your subscriber could be 1 million times different...

Yes you need a listener so that SQL knows where to route the connections when the group fails over.

You can create that as a traditional VNN listener or as a...

If the AG is all in sync you should just be able to Backup the log on the primary.

Then you will be able to issue a shrink file of the...

While I'm not an AWS expert by any means when you deploy an RDS instance of SQL it looks to in the backend just put the MDF/NDF/LDF/BAK/TRN all...

We are going slightly off on a tangent here as the OP mentioned AWS not Azure, but I do appreciate that both clouds will have the similarities and differences.

While I'm...

Please post sample data and expected outcome.

Please follow the guidance here

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

What type of upgrade are you planning to run?  Side by side?  In place?

Replication only works when the publisher and subscriber are within two versions of each other.

So if you...