Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    32

    Unanswered: cant rep but everything seems ok

    I have already set up the replication system - replication definition and
    subscription are ready, rep agent and DSI start without any error. However ,
    the rep agent seems cant get any message from the primary database and the
    pimary database can receive data from other primary database. What's wrong
    with rep agent.

    Please help !!

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Have you enabled replication using sp_setreptable? It gets me all the time, you setup everything and wonder why it isn't replicating. I have a reminder on my laptop that pops up every hour when I'm doing an engagement that says. "Have you done sp_setreptable or sp_reptostandby?"

    Sounds silly.. eh!!!

  3. #3
    Join Date
    Dec 2003
    Posts
    32
    I have already use 'sp_setreptable' on the table in the primary database

    But seems that the rep agent cant grab the message
    What's going wrong

  4. #4
    Join Date
    Oct 2003
    Location
    usa
    Posts
    8
    try the following :

    In the Primary Database

    sp_setreplicate
    sp_setrepproc

    In the PRS

    admin health
    admin who_is_down

  5. #5
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Hi,

    Are you doing a sp_reptostandby or repdefs / subscription ?

    Thanks,
    Vishi

Posting Permissions

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