Setting up an AOAG is no different in Standard as it is in Enterprise, everything is exactly the same, except the edition limitations you must use BAG's and not AG's,...

There is plenty on the internet for this topic on "how to setup a multi-subnet aoag" standard/enterprise doesn't matter it's the same thing you do, your just limited to 2...

Yes & Yes

But don't use mirroring it is depreciated and will be removed in a future version of the product.

No cannot be done in SSMS with registered servers

Can very well be NetBackup taking the backups.

Anything which integrates with the VSS/VDI API's can take a backup and write the information to msdb as it's a valid backup as...

Server side trace then, not as resource intensive as profiler.

Q1 - Use extended events and capture the logon event and the statement started events to capture which db's have queries run against them.

Q2 - For me always backup and...

What version of SSMS are you running 19.1?

IIRC that only supports SQL 2014 onwards, not SQL 2012.

So if you are using 19.1 you need to downgrade to an earlier version...

dupe post, original here

https://www.sqlservercentral.com/forums/topic/how-to-restore-on-newer-version

dupe post, original here

https://www.sqlservercentral.com/forums/topic/how-to-restore-on-newer-version

Exactly that, you will need to take it up a couple versions at a time, 2000->2008->2016->2022

2022 earliest it will support is 2012, so need to get it to at least...

On this line

count([ID])*100

Do this

count([ID])*100.0

Does that give you the decimal output?

If the table changes, the view doesn't change, this could cause you issue.

So you had this table

CREATE TABLE Table1 (
ID INT,
Firstname VARCHAR(50),
Lastname VARCHAR(50)
)

You create a view over...

You moving to Azure SQL DB (PaaS)?

You can't do cross database queries in the normal way on PaaS, you will need to use "SQL Elastic Query", so yes quite rightly...

Could do it in PowerShell and DBATools, call Get-DbaRegServer, loop round the result set from that and call Invoke-DbaQuery, write the result set to the CMS server.

But directly in SSMS...