Vertical filtering of a large replicated table introduces the potential for unwanted transactions to be pushed to the subscriber. This article talks about how you might avoid this.  Read more...

SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has been around in SQL Server for quite some time and allows you to scale out your environment. Warwick Rudd explains how to join these technologies together.   Read more...

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.   Read more...

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...

This paper provides a foundation for understanding data replication as well as a discussion of the criteria for selecting an appropriate replication technology.   Read more...

Microsoft IT protects against unplanned Transactional Replication outages and issues by using best practices and proactive monitoring. This results in increased stability, simplified management and improved performance of transactional replication environments.  Read more...

This article demonstrated the steps which you must follow to gracefully truncate the publisher database transaction log file by resetting replication.   Read more...

Learn how to clean up your orphaned replication settings.  Read more...

Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.  Read more...

This article will show you one way to quickly restore SQL Server replication with huge tables.  Read more...

Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats  Read more...

The final level of this Stairway takes you through how to identify and fix common errors.  Read more...

I have transactional replication configured in production. I have heard about the replication retention period, but what is the significance of this. Would there be any impact to my replication configuration if data is not synchronized with the subscriptions within the retention period?  Read more...

I have transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication database without affecting the replication configuration.  Read more...

One of the great features with SQL Replication is the ability to initialize a subscription from backup instead of from a snapshot. The official use for this is to take a database backup and restore it to a subscriber then replicate any additional changes to the backup.  Read more...

Introducing the replication monitor and how to use it to monitor replication health. It also introduces tracer tokens.  Read more...

How merge replication works, including the impact on the published database. The merge agent, different conflict situations and their resolutions are introduced.  Read more...

This level of the Stairway will cover the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.   Read more...

This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.   Read more...

I have transactional replication configured in my production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that you can use to reinitialize a subscription for transactional replication.  Read more...