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

Question

记得之前在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.

Answer 1

而且我查看distributor的属性中的publisher只有本机，并且类型就是snapshot的。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 2

What kind of subscription did you set?

Answer 3

What kind of subscription did you set?

Push subscription

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 4

How comes with Queued updating subscriptions job? Anyone set other replication on the server before? When are those jobs created? You can find out in job properties.

Answer 5

看时间是和我的那个快照发布一起创建的。

但是检查确实是没有其他的发布存在了。查看distribution数据库中的dbo.MSpublications

也只有我建立的那个发布存在。

 

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 6

SELECT * FROM distribution.dbo.MSqreader_history

中居然有一条记录，但是对应的publication_id居然是空的。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 7

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.

Answer 8

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.

Answer 9

Double check it in distributor properties.

Answer 10

Double check it in distributor properties.

是的，'Create QUeue reader agent' 这个选项是被勾选上的。

但是我在configure distributor的时候，好像没地方勾选或者不选这个option的。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 11

???... It didn't check by default, maybe someone configured distributor on the machine brfore?