SQL Server 2000 replication problem

[mortsdeh]

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

 

[Catadmin]

Have you checked the subscription to make sure it wasn't configured with an expiration date???

There are multiple reasons why a subscription can expire, including the fact that it's asking for a publication that has been altered from the one it was originally set up with. You may have to delete the subscription and re-create it.

Check the publication details too. Make sure it's still valid.





Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mortsdeh]

I have searched but I can't find where to check if the publication is valid. Any ideas?
/M

 

[Catadmin]

GO to the publication server. Drill down to Replication -> Publications. Is the publication server also serving as the Distribution server? If so, also check Replication Monitor.

It's been a while since I worked on Replication and I don't have it at my current work place, so I can't be explicit unfortunately. But you should be able to find the publication, right-click it and look at its properties to see if anything is wonky with it.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"