Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL
MSDN Fourms
Philippine SSUG
Fort Worth SSUG
Oklahoma City SSDG
Resume
MHS Enterprises
BlowFrog Software
FilAm Software
AcrylicAcetate.com
Bargain Humidors
Western Humidor

Replication Primer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

It will come as no surprise to anyone that things do not always go smoothly. Replication can and does crash. This is a simple fact of life that has not been solved yet. There is also no elegant way to recover replication in this event. The normal solution is to unsubscribe, resubscribe, and resynch to get replication flowing again. This is where the No option is utilized. In many cases, the subscriber will have all of the data already or at least a significant portion of it. You can get replication flowing again quickly by selecting this option and running a synchronization. No data or schema gets transferred, but the flag gets tripped telling SQL Server that it is OK to begin seding transactions. At this point, the immediate crisis is over. You can then go back to the publisher and figure out which transactions have not been transferred and move these by hand.

Select the Yes option along with the checkbox to distribute everything immediately and click the Next button to display Figure 14-40.

replication40.gif (25335 bytes)

Starting the SQL Server Agent on each subscriber.

The SQL Server Agent manages all of the replication activites. As such, it must be running in order for replication to work. This screen gives you the ability to start the SQL Agent service on each server. This service should always be running on your systems. If it has not been started yet, select the checkbox to start it. Click the Next button to display Figure 14-41.

replication41.gif (26882 bytes)

Completing the subscription.

Replication Primer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.