SQL Server Replication

I can remember several years ago every time someone mentioned SQL Server replication you would hear a dull groan. It is one of those things that certainly has some barriers to entry to learn how it works and what you need to do to keep it running. Not me, I get excited about working with replication. I work with several clients using replication some who replicate a single database to another server, and others who have several databases and several servers in replication, and one that has several databases with many SQL Servers being replicated.

SQL Server replication was introduced in the mid 1990’s, and has not changed too much. I would say the biggest changes were introduced in SQL Server 2005 with the introduction of SQL Server Management Studio.

Here are my recent posts on SQL Server Replication:

• SQL Server replication requires the actual server name to …October 24, 2020The more and more I work with replication the more and more I run into weird errors like this one. SQL Server replication requires the actual server name to make a connection to …SQL Server replication requires the actual server name to …Read More »
• Cannot drop the database because it is being used for replication.September 10, 2020I have been doing more and more replication work lately, and when recently testing some replication work I needed to create and drop some test databases and re-test the replication work. After configuring …Cannot drop the database because it is being used for replication.Read More »

Configuring Merge ReplicationJune 15, 2020This video is a 12 minute demo of how to quickly configure merge replication and to see it in action between SQL Server 2019 and SQL Server 2017. However most of what is …

Configuring Merge ReplicationRead More »

For merge publications, the version of the Subscriber must not exceed the version of the PublisherMay 29, 2020Working on a recent SQL Server merge replication project we needed to update some of the servers in a merge replication scenario without upgrading all of them. Consider a merge replication setup with …

For merge publications, the version of the Subscriber must not exceed the version of the PublisherRead More »

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!