|
|
|
Ten 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
|
|
|
|
|
SSCrazy
      
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
|
|
|
|
|
SSC 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.
|
|
|
|
|
Ten 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
|
|
|
|
|
SSCrazy
      
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
|
|
|
|
|
SSCrazy
      
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
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: 2 days ago @ 12:12 PM
Points: 1,186,
Visits: 1,857
|
|
Now data is reflecting...
Thanks
|
|
|
|
|
SSCrazy
      
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
|
|
|
|
|
Ten 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
|
|
|
|
|
Ten 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
|
|
|
|