Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

distrib.exe

1
October 24, 2011  2:00 PM

Working with replication snapshots to large to fit on your distributor



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

I ran across an interesting problem the other day.  I was setting up replication for a couple of VERY large tables.  These two tables between there are about 553 Gigs in size.  There isn't enough room on the distributor, and there is a slow link between the distribution server and the...

  Bookmark and Share     0 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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1