November 17, 2006 at 3:28 am
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
November 20, 2006 at 8:00 am
This was removed by the editor as SPAM
November 20, 2006 at 3:16 pm
Looks like you had an extended period of inactivity. If you look under the publisher properties there's a check box whicy by default is selected to "expire after some X number of hrs". The only way, unfortunately, is to reinitialize the snapshot.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
November 21, 2006 at 6:03 am
Thank you for the answer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply