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

  • 问题

  • 记得之前在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.
    2011年8月3日 3:21

全部回复

  • 而且我查看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.
    2011年8月3日 3:25
  • What kind of subscription did you set?
    2011年8月3日 3:35
  • 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.
    2011年8月5日 2:45
  • 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.
    2011年8月5日 3:11
  • 看时间是和我的那个快照发布一起创建的。

    但是检查确实是没有其他的发布存在了。查看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.
    2011年8月5日 3:20
  • 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.
    2011年8月5日 3:27
  • 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.
    2011年8月5日 14:23
  • 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.
    2011年8月6日 7:25
  • Double check it in distributor properties.
    2011年8月6日 15:39
  • 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.
    2011年8月8日 2:35
  • ???... It didn't check by default, maybe someone configured distributor on the machine brfore?
    2011年8月8日 3:21