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
SQL Server replication additional subscriber
Question I have a publisher with the distributor on the same server which is transactional replication. There is also an active subscriber using push method. I need to set a new subscriber up going to a different server using the same articles as the current … [Read More]
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.
How can I permanently remove replication by script if I only have access to the subscriber?
Question We’ve been building a replication network of DBs to give us some degree of Always On without paying the full price tag. Currently we have a publisher DB which replicates to a handful of subscribers, so that if the publisher goes down, we can … [Read More]
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]
Transaction Replication on AlwaysOn
Question In our AlwayOn environment I have two SQL servers 2014 Ent.edition (SERVER A, and SERVER B). I setup a transaction replication for [database A ], pointing to listener which shouldn’t cause any issue if a failover happened. Tested, worked just fine after a failover, … [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.