Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006

    Unanswered: SQL Server 2000 Replication problem


    I have set up transactional replication on two servers. The productionserver (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\Administrator. 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?


  2. #2
    Join Date
    May 2003
    Rochester, NY
    Check the 'Properties' of your publication and on the General tab is the settings for subscription expiration. I'd start there...

Posting Permissions

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