询问者
在sqlserver 2008 R2中配置了snapshot复制。怎么会出来这么多的Job。

问题
-
记得之前在sqlserver2000和2005的时候,配置了snapshot复制的时候,只有存在snapshot产生的Job和Distribution的job.还有一些过期清理的Job等。
但是现在在sqlserver 2008 R2中配置了snapshot复制之后,发现多了几个Job。
[NEOFISDB].8 --------category属于REPL-Queuereader,描述是:Reads queues for Queued updating subscriptions
居然还有Logreader的Job在执行。我记得只有在事务复制的时候才有Logreader存在的必要的。怎么也会出现这个了
If you haven't all the things you want,be grateful for the things you don't have that you didn't want.
全部回复
-
Tested it on my sql2k8 r2 server. Setting snapshot replication creates 8 jobs, 4 of them are cleanup jobs and 2 are alert jobs then 1 each for snapshot agent and distribution agent. Sounds correct to me and didn't see Queued updating subscriptions job. Did you choose 'create queue reader agent' when config distributor? Which creates QueueReader job.
-
Tested it on my sql2k8 r2 server. Setting snapshot replication creates 8 jobs, 4 of them are cleanup jobs and 2 are alert jobs then 1 each for snapshot agent and distribution agent. Sounds correct to me and didn't see Queued updating subscriptions job. Did you choose 'create queue reader agent' when config distributor? Which creates QueueReader job.
Where to set 'create queue reader agent' when configuring the distributor.
If you haven't all the things you want,be grateful for the things you don't have that you didn't want.