Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: replication problem

    MS SQL server 2000 sp4

    Added one article to replication a couple of weeks ago and just realized that it's no replicating.

    when I do a

    sp_helpsubscription @publication = 'MY publication'

    I see the article.. but it's not replicating. did a new snapshot and that didn't work.

    I reinitialized and then kicked off my REPL agent to run .. still not working

    doing transactional replication. log reader is running all the time and the distribution agent runs once evey 15 mins.. can anyone help?????

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Does the Snapshot agent give any error?

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    no errors from snapshot agent

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    And the article is associated with the correct subscriber? Was the table created at the subscriber? Is it empty, or does it just have stale data?

  5. #5
    Join Date
    Dec 2007
    Posts
    288
    it exists on the subscriber and it is not empty - it has stale data

  6. #6
    Join Date
    Dec 2007
    Posts
    288
    can someone tell me what the correct sequence of commands to drop this article from the subscription and readd it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •