The question says AdventureWorks. This is a public schema.

I think you likely have a good team. I think most of Redgate grinds. However, in many other places I've worked, relatively few people grind away at their careers.

It's the well known AdventureWorks database. All tables have PKs in there.

Nah, that's just poor communication. Most people suffer from this, including me, which is why I think AI use is ultimately going to be limited.

I can. The post also contains this (link removed):

Please share your io games insights and knowledge about this.

io games was linked. Not sure if this is a signature or if this is...

I'll admit I was struggling a bit to wrap a question around ANY. Suggestions welcome.

Apologies for the duplicate answer. That doesn't affect the question, but I'll award back points and change it to something else (wrong).

AGs are amazing. Wasn't sure you could, so didn't suggest, but that's essentially log shipping things.

Glad you have a solution

Tight coupling is great job security, at least until your org can't compete anymore.

Hard to know what you're doing here, as we can't see config. In general, I wouldn't use replication here.

I'd backup and restore. Once you have a full starting to restore,...

Do you mean that you have 2 nodes and workloads running against both (different dbs on each)? Is this a WSFC?

First, you should copy the db(s) to another system running...

Need to know the results, but the lag/lead approach is what I'd do, as @DesNorton has shown

It's not clear what install you're doing. I suspect your install is somehow broken and not correct in the registry somehow. I would re-download the MSI and use it.

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

No just typos. A happy accident.

I somewhat live by this. The world is very chaotic...