Replication and log shipping are two features of SQL Server that are used for managing data and ensuring that it is available in multiple locations. Both of these features can be useful for organizations that need to maintain multiple copies …
Backup Retention Part 1 Backup Retention Part 3 In part 1 I spoke about why you would want to restore from backups and some other reasons to have an older backup around. In part 2 I will dive more into …
I 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 a database for replication, then deleting the …
Cannot drop the database because it is being used for replication Read more »
Working with Transactional Replication with many of our SQL Server clients, one of the big questions that we are always asking is replication keeping up? Recently when deleting a few hundred million rows from a large table that is synced …
When working with SQL Server transactional replication, one of the common checks to see if things look healthy is to insert a tracer token into the replication data stream and see how long it takes to get to the subscribers. …
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 …
The 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 the server. Specify the actual server name. …
SQL Server replication requires the actual server name to … Read more »
I 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 a database for replication, then deleting the …
Cannot drop the database because it is being used for replication. Read more »
This 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 included here will work on SQL Server …
Working 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 a publisher, a distributor and 2 or …