Post reply

Replication isssue

  • October 11, 2010 at 10:34 pm

    #149018

    Data in few of the tables is out of sync. I am not able to find out which data is out of sync? Is there a way or some option under replication monitor which can show me the data which is out of sync? Also can i set up an alert when the data is out of sync? Btw this is transactional replication on sql server 2005 with push subscriptions.Thanks

  • October 12, 2010 at 12:37 am

    #1235318

    You can run a validation and findout which tables are out of sync. Compare the data between those tables which are out of sync. Lastly you can drop the problem table from publication and add it back.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • October 12, 2010 at 7:04 am

    #1235482

    thanks.....thats what i am exactly askng to how to do it...are there any dmv's or functions or any other option inside replication monitor which can say me if the DATA is out of sync or not?

  • October 12, 2010 at 10:09 am

    #1235668

    Replication has a built in tablediff tool. Its pretty basic but should do a good job.

  • October 12, 2010 at 10:20 am

    #1235678

    Thanks, this helps. One more thing related to replication monitor. I do not want to see any entries on replication monitor on my local machine, i use to look at it before but i do not want to now. is there a way i can clear cache inside replication monitor.? Thanks

  • October 13, 2010 at 2:16 am

    #1236024

    I'm sorry, I dont follow you. Do you mean you want to remove a registered publisher from replication monitor? If so, right click -> remove. If not can you explain a little further?

  • October 13, 2010 at 6:57 am

    #1236156

    ok...lets say you connect to server abc frm your local management studio and bring up replication monitor,then you close that and den connect to the sql installed in your local machine and bring up replication monitor you would see the publisher of server abc and also of ur local machine.Now i am asking how can you delete old entries from replication monitor,i do not want to break or remove repllication at all.hope this helps

  • October 13, 2010 at 7:11 am

    #1236170

    I was right 🙂

    Replication Monitor automatically registers new publishers when you connect through SQL Management Studio. It is completely safe to remove them from the monitor without any effect on replication.

    Right Click -> Remove

  • October 13, 2010 at 8:01 am

    #1236217

    hmm...i would like to test once..thanks

  • October 13, 2010 at 8:02 am

    #1236220

    Any idea on this one http://www.sqlservercentral.com/Forums/Topic1003225-146-1.aspx..?.thanks..

Viewing 10 posts - 1 through 9 (of 9 total)

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