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

    Unanswered: SQL Server 2000 Replication problem

    Hi,

    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?

    Best
    /M

  2. #2
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135
    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
  •