February 9, 2007 at 5:36 am
Hi Gurus
I have an issue where the subscribers are not getting in sync with the publisher on time. Every time I have to manually restart the job to synchronize them. Any idea where i am missing something. Areas that I need to check?
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
February 9, 2007 at 5:52 pm
Distributor agent jobs may be stopped ...
If you want continuous replication by default sql add the schedule to run when agent starts... you can add another schedule to run every 1 or 2 so that job will start automatic if it fails for any reason..
MohammedU
Microsoft SQL Server MVP
February 14, 2007 at 2:37 am
Hi, back to basics first. Is the log reader and Distribution agents configured correctly. Can you see them under Replication Monitor. Can you see the jobs in SQL Server Agent. Is SQL Server Agent running. Is -continous a parameter in the jobs. As a by the way, is there more than one subscriber and are they pull subscriptions ? Thanks Derek
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply