locked
Snapshot replication : no replication transactions are available. RRS feed

  • Question

  • Hi All,

    We have the snapshot replication set up. I see that publisher has 221 records and subscriber has 113 records. When i tried to run the replication job .  job succeded but as out put i got no replicated transactions are available.

    Then i re ran the snapshot agent. and i checked that snapshot generated with 221 records. Again i started the replication from view synchronization status and increased the -outputverboselevel 2 and I see that.

    2014-11-25 12:01:02.526 OLE DB Distributor '': {call sp_MSget_subscription_guid(130)}
    2014-11-25 12:01:04.307 sp_MSget_repl_commands timestamp  value is: 0x0x00005ad30000001600020000064a
    2014-11-25 12:01:04.307 The commit timestamp  value is: 0x00005ad30000001600020000064a
    2014-11-25 12:01:04.307 No replicated transactions are available.
    2014-11-25 12:01:04.932 Adding alert to msdb..sysreplicationalerts: ErrorId = 0, 
    Transaction Seqno = 0000000000000000000000000000, Command ID = -1 

    Please suggest why data is not replicated. I can do the re initialization here.. but i don't want to do it.

    I want to understand the problem here. Why the 90+ records are not getting replicated.

    Please help 

    Thank you!!

    • Moved by Olaf HelperMVP Friday, November 28, 2014 5:41 PM Moved from "Database Engine" to a more related forum for a better response
    Tuesday, November 25, 2014 12:36 PM

Answers

  • Are you sure its snapshot replication and not transactional?

    As far as I know snapshot replication puts the entire snapshot to the subscriber. Which is exactly same as what a reinitialization do. it doesnt do incremental updates.

    Did you run the distribution agent after the snapshot agent is run?


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by Donghui Li Sunday, December 21, 2014 7:55 AM
    Tuesday, November 25, 2014 12:57 PM

All replies

  • Are you sure its snapshot replication and not transactional?

    As far as I know snapshot replication puts the entire snapshot to the subscriber. Which is exactly same as what a reinitialization do. it doesnt do incremental updates.

    Did you run the distribution agent after the snapshot agent is run?


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by Donghui Li Sunday, December 21, 2014 7:55 AM
    Tuesday, November 25, 2014 12:57 PM
  • Hi Khushi,

    Does the suggestion provided by Ashwin above solve your issue? If the issue persists, please post the detail information about your issue, so that we can make further analysis.

    Regards,
    Jerry Li

    Tuesday, December 9, 2014 9:06 AM