Thanks for the reference.

Oh, it's not my company, I've been brought in to consult on some other problems, and the use of the Version Store cropped up as...

Thanks for the reference.

Please don't EVER tell me to RTFM, especially given that I mentioned I'd done a bunch of reading. I've been searching for a reference like this for...

Further to this post, I have another post regarding CMEMTHREAD Waits, which is the same client (https://www.sqlservercentral.com/forums/topic/cmemthread-waits-2)

The database is 3.6TB, and their indexes are seriously fragmented, even the clustered...

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...