February 17, 2011 at 6:42 am
hello experts,
yesterday i was getting some problem of performance on my server. i found 4 jobs of replication were running on server so i disabled thease jobs. but today i have enabled the jobs again but the status of jobs not showing "running". i am very new in replication, can any body let me know how can i know which type of replication is configured on my server.
and can i start the all (4) the jobs from 1st step anyway directly??
thanks in advance
February 17, 2011 at 7:51 am
Easiest way to find is through SSMS. You just need to expand the Replication folder and move the mouse over the Publication. It will show the replication type.
-Roy
February 17, 2011 at 8:28 am
ohh thanks..., so in transactional replication, after disabling jobs when we enable them again, dont they work as same previous they working or i need to start all the jobs and is it ethical for transactional replication to work fine as it was before.
February 17, 2011 at 8:39 am
The answer would be It Depends.
Theoretically it will pick it up from where it was left off, but if the replication thinks that the data is way out of synch, then it will have to do Snapshot once again.
Can you give us a bit more details regarding your replication set up? Are you running the distributor on the Publisher server itself or is it a separate server?
Launch your replication monitor and click on your Publication. There is an agent tab, click on it and see what is the status of the Snapshot Agent and Log Reader Agent?
It is always better to stop and start agents through the replication monitor. Dont use the Job Activity monitor to stop and start Jobs for replication.
-Roy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply