SQL Server 2000 Replication problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mortsdeh
    New Member
    • Oct 2006
    • 2

    SQL Server 2000 Replication problem

    Hi,

    I have set up transactional replication on two servers. The productionserve r (PSERV) and a backup server (BSERV).

    On PSERV I have started the agents Snapshot (running with status Succeeded) and Log Reader.(running with status Idle and the message "No replicated transactions are available").

    On BSERV I choose start syncronization on my subscription. When I go into Job history I can find the following information on four lines:
    The job failed. The Job was invoked by User SERV\Administra tor. The last step to run was step 1 (Run agent.).
    The subscription to publication '(null)' has expired and does not exist. The step failed.
    Connecting to Distributor 'SERVP'
    Connecting to Subscriber 'SERVB'

    Anyone that have any ideas on how I can fix this problem?

    Best
    /M
Working...