SQL Server with Mr. Denny:

Replication


July 27, 2009  11:58 AM

Push vs. pull: Configuring SQL Server replication



Posted by: Denny Cherry
Replication, SearchSQLServer.com, SQL Server

I've published a new artcile over on SearchSQLServer.com.  This article is titled "Push vs. pull: Configuring SQL Server...

Bookmark and Share     2 Comments     RSS Feed     Email a friend

May 11, 2009  11:00 AM

How do I change from push to pull subscriptions in SQL Replication?



Posted by: Denny Cherry
distrib.exe, Replication, SQL Server 2000, SQL Server 2005, SQL Server 2008

The official answer is to delete the subscriber and recreate it pushing a new snapshot to the subscriber. The much quicker and easier method is as follows. 1. Stop the distribution agent on the machine that it's currently running on. 2. Disable the SQL Agent job that runs the distribution...


May 7, 2009  11:00 AM

Pull vs. Push Subscriptions? Which one should you use?



Posted by: Denny Cherry
Replication, SQL Server 2000, SQL Server 2005, SQL Server 2008

This is a "it depends" sort of question. These are my recommendations, your mileage may vary. Your distributor is on the same system as your publisher - Pull is probably for you Your Subscribers are a very high transaction count - Push is probably for you You need to manually copy the...


September 29, 2008  11:00 AM

Decreasing Network Traffic and Network Latency When Using Replication



Posted by: Denny Cherry
Network Latency, Network Traffic, Replication, SQL Server

When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these...


September 1, 2008  11:00 AM

Getting more error data from SQL Server Replication



Posted by: Denny Cherry
distrib.exe, logread.exe, OutputVerboseLevel, Replication, replmerg.exe, snapshot.exe, SQL Server 2000, SQL Server 2005, SQL Server 2008

The error reporting in SQL Server Replication isn't all that great.  This is a well known issue that pretty much everyone knows about.  Something that I don't know if a whole lot of people know about, is that there is a way to get a lot more information from replication about what's going on, and...


January 14, 2008  8:00 AM

Log Shipping without SQL Server Enterprise Edition



Posted by: Denny Cherry
DR, Log Shipping, Replication, SQL, T/SQL

Microsoft's Log Shipping is pretty good.  But it requires that you have SQL Server Enterprise Edition on both the machines.  This makes the solution fairly expensive.  Because of this I've written a replacement which can be used on any edition of SQL Server including SQL Server Express Edition...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: