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 15 (of 15 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy