Isn't that the whole "reason to be" for Ag's ?

When the partner instance comes back online and is visible to the primary instance, it will pickup log-processing from primary to...

Capture failed logins using extended events !

This may get you started: "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events" as it gives you more...

Jep .... that's also part of life 🙂

I copy-pasted your text and commented all but the ddl and the queries.

Works just file.

Off course, in SSMS you need to keep the consequences of any "GO" line in mind...

Talk with your db's consumers if they changed usage / implement new stuff / have faulty processes recently / ...

btw: If you hover over the icon, you’ll get an explanation of it

explained at: "What is a contained availability group?"

check the sql server errorlog file

You've got the correct clustered index on CDPOS, except perhaps that it's not unique.  If adding CHANGENR to the clus index will make it UNIQUE, you should do that.

Either...

The first thing I would check is the amount of disk space available.

Also, I would rarely use RESTORE...WITH REPLACE. I would normally restore to something like MyDb202405301201 and then...

Your script seems to be what it needs to be.

Which version number is your target sqlserver instance ? ( did you apply the (near) latest cumulatieve updates

ref: SQL Server...

Thank you for the feedback 🙂

If you only take full and diff backups, I assume your databases are in simple recovery model ( or your db log file(s) will keep on growing after the first...

You need to grant the sql server service account auth to get to the new backup file location/share

IMHO AzureMI have been brought to life to have people be more keen to (try to) migrate and land on an environment they are familiar with.

• DBMail needs specific attantion

...