Original DBCC CHECKDB output would be helpful, with no outputs available would be safe to say data loss is unknown

if you knew what table(s) or index(es) were affected could restore...

Paul Randal details backup with checksum on this blog

https://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2730-use-backup-with-checksum-to-replace-dbcc-checkdb/

What errors did checkdb report?

how often do you run dbcc checkdb on your databases?

My database was in suspect mode, and when I checked using DBCC CHECKDB, it returned errors.

As mentioned in the link below, I used the REPAIR_ALLOW_DATA_LOSS option with the DBCC...

with a busy 40TB db i would think the reason the AG does not failover immediately is due to the outstanding redo queue, it is multi threaded in later versions...

If it were that easy, I would. The structure...

It seems Question was incomplete.

If we consider Always ON ( Sync - Automatic failover) is on Windows cluster, Primary complete down is possible with Primary server switch off /...

Do you have the SQL iaas agent registered on the vm?

There is a firewall rule which only allows access via 1433 and 1434 UDP.

[\quote]

can this not be modified\updated to allow the named instance port

So I Switched off the...

sql agent on MI offers less than unmanaged instances

Alerts on MI are created at the Azure resource level, check out alerts and diagnostic...

sys.dm_exec_sessions has the login_name column and host_name column

Azure SQL MI is restricted in what they support, alerts are generally configured on the MI settings in the portal

the code creates the drop commands and the create commands, it's for dev use so test it first to ensure it does what you require

Hi

We have an on prem power BI running on a physical SQL2022 enterprise box with SA. Working fine, and legal.

For DR reasons I am considering moving just the web...

can you supply a little more detail please on exactly what it is you're doing and any error numbers produced from the sql server error log.

Also, how often is DBCC...