Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication Isuse Expand / Collapse
Author
Message
Posted Tuesday, August 28, 2012 1:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 16, 2014 10:44 AM
Points: 153, Visits: 583
I am new to replication, just started learn it and implementing it.
the questions may be silly...thanks in advance.

1) I see a message in PUB to DIST Tab: 'approximately ******* log records have been scanned in Pass #3.0 of which were marked for replication' what is message for?
I have checked Distribution database log and looks fine.

2) Undistributed commands tab:
Number of commands in ditribution databases waiting to be applied to the Subscriber: 10293164? This means they are 10293164 records pending to apply at Subscriber.

3) Estimated Time : 00.55.02, I can relay on this time showing?

4) When I try to do Tracer Tokens: Insert Tracer
PUB to DIST: 00:00:02
DIST to SuBS: Pending
Total Latency : Pending
It will in pending sate for the whole day...That means the transactions are not applied
at SUBS? Any alternate way to

5) How can I check the replication is working state?

6) How can I know the pending transaction?




Post #1351214
Posted Wednesday, August 29, 2012 12:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:17 AM
Points: 1,101, Visits: 5,279
Check the distribution agent job history.
You might find some clues there.
Post #1351408
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse