Post reply

Replication Problem?

  • October 14, 2009 at 7:49 am

    #216354

    Hi.

    My transactional replication has a problem. I was adding some items and suddenly gave problem and closed the SSMS. When he returned, got the following message: "The subscription to this publication is not active yet. No user action is required."

    This is a problem? The number of Undistrubuted Commands keeps increasing, but does not replicate.

    Thanks!!!

  • October 14, 2009 at 7:51 am

    #1065674

    Yes, it is a problem. Try restarting the log reader agent and the snapshot agent.

    -Roy

  • October 14, 2009 at 8:03 am

    #1065688

    I try this and not work. Other any suggestions?

    Thanks

  • October 14, 2009 at 8:11 am

    #1065701

    Reinitialize the subscription.

    -Roy

  • October 14, 2009 at 8:26 am

    #1065717

    I try this and not work again.

    Thanks

  • October 14, 2009 at 8:59 am

    #1065745

    Replication can be fickle. Sometimes it seems reinitialising just doesn't work and we have to recreate the entire replication job again.

  • October 14, 2009 at 9:10 am

    #1065757

    Drop the subscription and add it back again. When your SSMS crashed while setting up replication might have not completed the required entries.

    -Roy

  • October 14, 2009 at 9:13 am

    #1065760

    But i have transactions not been replicated. If drop and create, this transactions will be replicated?

    thanks.

  • October 14, 2009 at 9:16 am

    #1065763

    When you are dropping the subscription and re adding them, you will be able to initialize using snapshots. Then what ever is missing now will also be there.

    -Roy

  • October 14, 2009 at 10:57 am

    #1065849

    Ok. I will recriate the subscription.

    Thanks again!

  • October 14, 2009 at 2:37 pm

    #1065975

    Please do let us know if it worked.

    -Roy

  • October 15, 2009 at 12:34 pm

    #1066435

    Hi Roy.

    I recreated the replication and everything worked again.

    Thanks!

  • October 15, 2009 at 12:42 pm

    #1066443

    I am glad that we could help.

    -Roy

  • January 6, 2012 at 4:25 am

    #1429546

    I had the same problem adding articles. I removed the articles from replication and re-added them. Replication fixed.

    --Bob Luther

  • May 22, 2015 at 4:53 am

    #1799955

    Check for Status column in MSSubscriptions table, it should be always value 2, any other than value 2 update it and check, the halted replication commands should start replicating to subscriber.

    --- Checking Query --

    select status, * from distribution..MSsubscriptions where status <> 0

    --- Update Query

    update distribution..MSsubscriptions set status=2 where status <> 0

    ---

    Thanks & Regards,

    Bhaskar Shetty

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply