This is not part of a DR solution but for a reporting solution.

It's a client's system, so we can't upgrade or buy things like Litespeed or Red-Gate. There's no apatite...

Interesting, but I don't think, modifying the triggers would break the Snapshot Replication. This would need to be tested. I doubt he broke anything, it's more likely an update that...

I tend to agree with Sue_H on this, there are processes doing a lot of updates every now and then (batch loads, etc.) and yes, the log records will be...

Admingod, you have a number of questions and comments that haven't really been answered, and you may need to supply some more info to get some answers.

You mention finding the...

I don't have a problem with Try/Catch brackets, and I would always encourage developers to use them. I have a problem with this being  the "solution". A Try/Catch is a...

Deadlocks are not the same a blocking, and are typically resolved in a few milliseconds, you won't see them in your blocking alert and lowering your blocking threshold won't change...

You may want to move this topic to the SQL 2019 forum here:  https://www.sqlservercentral.com/forums/forum/sql-server-vnext?view=all

This is a known issue, and we have also seen it, plus seen it in SQL Server 2017, although I can't recall at what CU level. We found that Log...

No, a new Subscription shouldn't affect the existing subscription.

Why use a backup and restore rather than Snapshot? Because it's going to take a looooooooong time to snapshot a 2TB database...

1. If the original Subscription was setup with a Backup, then the option must be set, but I'd check any way
2. Since one of the nodes in your proposed AG...

1. It shouldn't break the current subscription HOWEVER... If the Publication has not been configured to allow Synchronize from Backup, you will need to set this option. It may, but...

The basic process is simple, you just need ta add the Azure server as a subscriber to the existing Publication, and use a backup to establish it. Te actual step...

I'm not sure this is the place to get your code rewritten for you.

You would at least need to tell us where some of the bottlenecks are. The problem could...

As has been said, the other way around. The "HEAD" is the problem, so SPID 71 is blocking 67.

Also each extra indent indicates another layer of blocking. In a busy...

Someone has a server restart scheduled for 7:05 pm every night?

There are relatively few things that would force a connection to close, but a restart or Availability Group fail over...