SQLServerCentral.com Articles tagged Replication

High IO Wait on SQL Server Replication Distribution Database

Tue, 04 Jun 2013 06:00:00 UT

Have you ever heard this question? The database refresh has gone from 10-15 minutes to 1.5 hours. Nothing has changed on the application server and the consultant said ask the DBAs to check the database server. Where do you start to find the problem? Check out this tip to learn more.

Super Fast Transactional Replication Repair

Thu, 30 May 2013 06:00:00 UT

Your production SQL Server transactional replication just failed and the business impact is critical. How do you get replication restored in minutes?

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Populating a Vertically Filtered Replicated Table

Wed, 20 Mar 2013 06:00:00 UT

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.

Expanding AlwaysOn Availability Groups with Replication Publishers

Tue, 12 Feb 2013 07:00:00 UT

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.

Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication

Wed, 26 Dec 2012 07:00:00 UT

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.

Disaster In The Real World - #2

Fri, 14 Dec 2012 07:00:00 UT

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.

Data Distribution with SQL Server Replication

Mon, 10 Dec 2012 07:00:00 UT

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

Designing & Maintaining SQL Server Transactional Replication Environments

Fri, 12 Oct 2012 06:00:00 UT

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.

Process to truncate transaction log of replicated database

Tue, 24 Jul 2012 06:00:00 UT

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

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Steps to clean up orphaned replication settings in SQL Server

Thu, 05 Jul 2012 06:00:00 UT

Learn how to clean up your orphaned replication settings.

Transaction Replication Publisher failover to Mirror

Thu, 28 Jun 2012 06:00:00 UT

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

The Trouble with Transactional Replication and large articles.

Fri, 18 May 2012 06:00:00 UT

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

Transaction Replication Latency Diagnosis

Wed, 09 May 2012 06:00:00 UT

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

Stairway to SQL Server Replication - Level 10: Troubleshooting

Wed, 18 Apr 2012 06:00:00 UT

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

Understanding Retention Periods for SQL Server Transactional Replication

Tue, 17 Apr 2012 06:00:00 UT

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?

Renaming a Published SQL Server Database

Tue, 10 Apr 2012 06:00:00 UT

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.

Init Replication From Backup

Mon, 02 Apr 2012 06:00:00 UT

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.

Stairway to SQL Server Replication - Level 9: The Replication Monitor

Wed, 21 Mar 2012 06:00:00 UT

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

Stairway to SQL Server Replication - Level 8: Merge Replication – How it works

Fri, 02 Mar 2012 07:00:00 UT

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

Stairway to SQL Server Replication - Level 7: Merge Replication – Subscription

Fri, 03 Feb 2012 07:00:00 UT

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.

Stairway to SQL Server Replication - Level 6: Merge Replication - Publication

Fri, 13 Jan 2012 07:00:00 UT

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.

Options to reinitialize subscriptions in SQL Server replication

Tue, 27 Dec 2011 07:00:00 UT

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.

Options to not replicate SQL Server DELETE commands

Fri, 04 Nov 2011 06:00:00 UT

I have transactional replication configured in my production environment. The business team has requested that I do not replicate delete operations on certain articles. In this tip we look at a couple of options to not replicate DELETE commands.

An Easy Way to Monitor SQL Server Replication

Wed, 26 Oct 2011 06:00:00 UT

In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.

Update multiple servers in a single bound

Mon, 24 Oct 2011 06:00:00 UT

Learn how you can update multiple servers in a single bound with this technique from Kimberly Killian.

Centrally collect replication conflicts and send an alert

Mon, 17 Oct 2011 06:00:00 UT

Automatically capture replication conflicts and generate an automated email notification.

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

When Did Merge Replication Subscribers Last Sync?

Thu, 18 Aug 2011 06:00:00 UT

The article presents an automated process to see when remote servers last synced to publisher and send notification reminders.

Stairway to SQL Server Replication - Level 5: Transactional Replication & How it works

Wed, 20 Jul 2011 06:00:00 UT

Monitor SQL Server Replication Jobs

Mon, 11 Jul 2011 06:00:00 UT

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.

SQL Server Replication: Providing High Availability using Database Mirroring

Tue, 17 May 2011 06:00:00 UT

This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.