Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLREPL

A blog about SQL Server Replication.

Central Subscriber Model Explained

The majority of SQL Server Replication topologies are based on the Central Publisher model, which is comprised of a single publisher replicating to one or more subscribers.  Another replication model, which is sometimes overlooked, is the Central Subscriber model, which is comprised of multiple publishers replicating to one subscriber using… Read more

5 comments, 716 reads

Posted in SQLREPL on 28 January 2013

Chad Churchwell: Protect Your Replication Environment with AlwaysOn Availability Groups

Heads up everyone.  Next Tuesday January 22nd, 2013 Chad Churchwell (blog | twitter) will be presenting a webinar on behalf of Pragmatic Works on protecting your replication environment with AlwaysOn Availability Groups.  I've had the pleasure of following Chad over the last year and have really come to… Read more

0 comments, 532 reads

Posted in SQLREPL on 16 January 2013

Auditing changes in Merge Replication

One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes in Merge Replication.  This is useful when troubleshooting issues such as identifying where data changes are coming from, who is causing them, and what the data is before and after… Read more

4 comments, 1,480 reads

Posted in SQLREPL on 10 October 2012

Implementing a replication agent progess bar

Using Replication Management Objects, SQL Server subscriptions can be synchronized programmatically without using SQL Server Agent or SQL Server Management Studio.  Common uses include:

  • Express edition subscribers
  • Sync from within an application on-demand without an agent job
  • Display agent status information in an application

In a previous post I provided… Read more

12 comments, 1,063 reads

Posted in SQLREPL on 6 May 2012

PASS DBA Virtual Chapter: Replication with Hilary Cotter

I’m pleased to announce that this Wednesday April 11th 2012 Hilary Cotter will be presenting for the PASS DBA Virtual Chapter on SQL Server Replication.  Replication is a powerful and flexible data distribution solution that has become one of the more mature features in SQL Server.  Come listen to Microsoft… Read more

2 comments, 870 reads

Posted in SQLREPL on 10 April 2012

Synchronizing subscriptions in SQL Server Express

I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a SQL Server Agent, and what to do about it.  Since SQL Server Express does not include the SQL Server Agent, pull subscriptions must be synchronized by some other means.  The… Read more

8 comments, 1,552 reads

Posted in SQLREPL on 12 March 2012

Executing scripts with sp_addscriptexec

Looking for ways to do things more quickly and efficiently, I thought I would talk a little bit about sp_addscriptexec and how it can be leveraged to expedite the process of executing SQL scripts in a replication topology.  By creating and saving a SQL script on a publisher, it can… Read more

9 comments, 1,079 reads

Posted in SQLREPL on 10 February 2012

Arithmetic Overflow in sp_MSarticle_validation

This is probably a rare occurrence — but I've noticed that data validation for an article with 10 billion or more rows will fail due to an arithmetic overflow error in sp_MSarticle_validation.

Data validation for a specific article in a transactional publication is done using sp_article_validation which in turn… Read more

0 comments, 542 reads

Posted in SQLREPL on 7 February 2012

Creating merge replication conflict alerts

One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in a topology. In an earlier post I demonstrated how to handle conflicts using the business logic handler framework - now I would like to show how to create Merge Replication… Read more

1 comments, 672 reads

Posted in SQLREPL on 28 January 2012

How to set the default replication agent profile

Over the last couple of years I've come to the conclusion that the default replication agent profiles just don't cut it.  For example, usually I want my replication agent jobs (Snapshot, Log Reader, Distribution, or Merge) to have a custom replication agent profile which differs from the default agent profile.… Read more

0 comments, 1,788 reads

Posted in SQLREPL on 22 January 2012

Error when creating a subscription

When creating a subscription in SQL Server sometimes the following error will occur:

The remote server "%s" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.

The error is pretty straightforward and indicates that the replication agent… Read more

0 comments, 917 reads

Posted in SQLREPL on 17 January 2012

Extending the Publisher to the Cloud

SQL Azure Data Sync

This weekend I decided to setup a SQL Azure sync group to synchronize a SQL Azure database with an on-premise replication publisher.  I was curious if this would work, as I’ve been unable to find any documentation stating whether or not SQL Azure Data Sync can… Read more

2 comments, 724 reads

Posted in SQLREPL on 15 January 2012

How to let non-admin business users run replication agent jobs

This blog post is basic in nature but highlights a very real requirement that may arise when administering replication.  Occasionally we, as Database Administrators, need to grant non-administrator business users the ability to run replication agent jobs due to business needs.  Instead of giving the business user the ability to… Read more

2 comments, 1,407 reads

Posted in SQLREPL on 13 January 2012

Making Schema Changes in a Replication Topology

I've noticed in the forums there have been a number of people inquiring about making schema changes in a replication topology.  I understand the concern and I'm here to assure you that yes, it is possible to do.  If you think about it, DDL statements are used to create and… Read more

0 comments, 1,129 reads

Posted in SQLREPL on 10 January 2012

Undocumented Gotcha in Merge Replication Tracking

In the spirit of Robert Davis's (blog | @SQLSoldier) blog post: Undocumented Gotchas of Transactional Replication, I decided to contribute an undocumented gotcha in Merge Replication to his list.  First, let me start off by saying that if you happen to have a difficult replication scenario that… Read more

1 comments, 789 reads

Posted in SQLREPL on 18 December 2011

Counting Merge Replication Article Changes

One of the cool things about Merge Replication is that it has the capability of revealing very interesting information regarding applications and their associated statements ran against published articles.  We can learn quite a bit about an application just by the sheer number of data changes that are replicated as… Read more

0 comments, 1,012 reads

Posted in SQLREPL on 16 December 2011

Replication Bookmarks

I started a list of the resources I frequent the most in the MSDN Library SQL Server Books Online - Replication, Technical Articles and Whitepapers, Blogs and Websites, Videos, Forums, and Books - Replication Bookmarks.

I find myself visiting these pages often and thought this could be a useful… Read more

0 comments, 664 reads

Posted in SQLREPL on 12 December 2011

The process could not read file due to OS error 3

When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error:

The process could not read file X:\Program Files\Microsoft SQL Server\<instance>\MSSQL\repldata\<snapshot>\<snapshot_file> due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20016)
Get help: http://help/MSSQL_REPL20016
The system cannot find the path specified.
(Source:… Read more

16 comments, 10,084 reads

Posted in SQLREPL on 30 November 2011

Merge Business Logic Handler Conflict Resolver

Introduction

This example demonstrates how to implement a business logic handler for a Merge article to perform custom resolution of conflicting update data changes that occur at Publisher and Subscribers.

Building the Sample

This sample was built using Visual Studio 2010.

Description

With Merge Replication you can utilize the business… Read more

1 comments, 669 reads

Posted in SQLREPL on 13 November 2011

Merge Business Logic Handler Custom Conflict Resolver

Introduction

This example demonstrates how to implement a business logic handler for a Merge article to perform custom resolution of conflicting update data changes that occur at Publisher and Subscribers.

Building the Sample

This sample was built using Visual Studio 2010.

Description

With Merge Replication you can utilize the business… Read more

2 comments, 1,279 reads

Posted in SQLREPL on 13 November 2011

Older posts