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 12»»

transactional replication Expand / Collapse
Author
Message
Posted Tuesday, June 30, 2009 4:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 1,186, Visits: 1,857
I have successfully implemented Transactional replication yet only tables which has primary key has populated on subscriber and the data is also not replicating on subscriber. I have used push subscription and no schedule.

Thanks

Post #744277
Posted Tuesday, June 30, 2009 5:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620
guptaajay1985 (6/30/2009)
I have successfully implemented Transactional replication yet only tables which has primary key has populated on subscriber and the data is also not replicating on subscriber. I have used push subscription and no schedule.


The first criteria of transactional replication is you should have a primary key on the table you want to publish. I didn't understand 2nd part of your question.





Pradeep Singh
Post #744293
Posted Tuesday, June 30, 2009 5:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, September 17, 2012 3:36 AM
Points: 32, Visits: 346
Schedule it (or) Start the process thru Replication monitor or run the relevent job in sqlagent --> jobs. Ensure the Log reader agent is in running state.
Post #744300
Posted Tuesday, June 30, 2009 5:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 1,186, Visits: 1,857
Dear PS,

2nd part means if I am changing any data at publisher side then it should also reflect at subscriber side immediately,but it is not.
LogReader is in running state is visible in replication monitor


Thanks

Post #744306
Posted Tuesday, June 30, 2009 5:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620
your log reader agent must be running continously or at specified intervals to read the log of the published database and bring 'changes' to subscribed articles to the distribution database. Once the transactions are moved to the distribution db, the distribution agent moves the database to the subscribers.
As suggested by Rajan, your log reader job must be scheduled for the transactions to move to distribution db.

side-effect - Since you've not scheduled your log reader agent, your publisher db's log will keep on growing (backing up the log wont truncate log as the db is replicated).





Pradeep Singh
Post #744311
Posted Tuesday, June 30, 2009 5:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620
ps (6/30/2009)
your log reader agent must be running continously or at specified intervals to read the log of the published database and bring 'changes' to subscribed articles to the distribution database. Once the transactions are moved to the distribution db, the distribution agent moves the transactions to the subscribers.
As suggested by Rajan, your log reader job must be scheduled for the transactions to move to distribution db.

side-effect - Since you've not scheduled your log reader agent, your publisher db's log will keep on growing (backing up the log wont truncate log as the db is replicated).


EDIT - corrected word in BOLD above.





Pradeep Singh
Post #744315
Posted Tuesday, June 30, 2009 6:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 1,186, Visits: 1,857
Now data is reflecting...

Thanks

Post #744334
Posted Tuesday, June 30, 2009 6:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620
Glad you got it working.
did you schedule the job to run at specific intervals or manually ran it once? I suggest u schedule it at regular intervals (may be off-peak hours too).





Pradeep Singh
Post #744345
Posted Tuesday, June 30, 2009 10:41 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 1,186, Visits: 1,857
Should I schedule all jobs or which one I should schedule


AjayG-----publisher/distributor machine name
cicenrich--database name
MADANB--Subscriber machine name


These are the jobs:


Agent history clean up: distribution
AJAYG-cicenrich-1
AJAYG-cicenrich-Pub_enrich-1
AJAYG-cicenrich-Pub_enrich-MADANB-3
Distribution clean up: distribution
Expired subscription clean up
Reinitialize subscriptions having data validation failures
Replication agents checkup
Replication monitoring refresher for distribution.


Thanks

Post #745070
Posted Tuesday, June 30, 2009 10:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 1,186, Visits: 1,857
one more error:

" The row was not found at the Subscriber when applying the replicated command"

in view synchronization monitor


Thanks

Post #745076
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse