Can I use both Log Shipping and Transaction Replication at the same time?
Rich Vieira asks about the feature compatibility of using AlwaysOn Availability Groups and Replication on the same database.
replication
Replication latency when an Availability Group replica is offline
Assume you have configured a transactional replication publisher, which is part of an availability group (AG). Now, you have an asynchronous secondary AG (or mirroring) replica that is offline. Perhaps this is a DR node, and you are doing patching or other planned maintenance on … [Read More]
Configuring the distribution database in an Availability Group
Starting with SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3, you can now configure your distribution database as part of an Availability Group (AG). I found one spot where a minor change made a few of my scripts blow up.
Configuring Replication with Availability Groups
I’ve used replication and Availability Groups together before. Replication works great with an AG as both a publisher or a subscriber (though, not as a distributor–you can’t add the distribution database to an AG). I was surprised when I recently ran into a problem configuring … [Read More]
Podcast: Mirroring, Availability Groups, Replication, and Log shipping
Have you ever wondered what the best option is for making your data available in your environment? I was asked by Carlos L Chacon (blog|twitter) to be part of a panel on his podcast for an episode discussing some of the options–availability groups, mirroring, log shipping, and replication. We … [Read More]
Moving Replication to a new server (without re-snapshotting)
At this job, we used transactional replication extensively with dozens of publications pointing at multiple subscribers. We wanted to migrate the publisher without having to re-snapshot all of the publications. This is how we did it.