locked
Replication issue from Oracle to SQL Server RRS feed

  • Question

  • We have SQL Server 2008 64bit on windows 2008 and Oracle 10G. Some data is not getting replicated from Oracle to SQL Server, the distribution agent job runs fine and I do'nt see any errors. To make sure I also restarted log reader agent, reinitialized subscriptions etc. but even then some data is still missing. The distribution agent job is schduled to run every 15 minutes. It is transactional replication.

    Any ideas. Thanks!


    sqldev
    Thursday, October 7, 2010 4:17 PM

Answers

  • Hello ,

     

    Is it failing on any particular article. Can you collect  verboose log and paste the output (How to enable replication agents for logging to output files in SQL Server  http://support.microsoft.com/kb/312292)

     

    Thank You

     

    Jayaprakash JO - MSFT

    Thursday, October 14, 2010 12:44 AM
    Answerer