Replication keeps snapshotting the same tables

• TDP

  Ten Centuries

  Points: 1144

  More actions

  November 7, 2013 at 8:11 am

  #285834

  Hi

  I am creating replication atm and one of my publications (the distribution job) seems to be in a loop delivering the snapshot to the subscriber.

  The distribution has delivered the snapshot 3 times already. As soon as it delivers the snapshot successfully, it start at applying the scripts and bulk copying the data again. I have gotten the msg below 3 times already (have stopped it now)

  "Delivered snapshot from the 'unc\SERVERANDPUBLICATIONNAME\20131107144443\' sub-folder in 1413954 milliseconds"

  At the end of this post you can see the replication history from MSdistribution_history. I have removed some table entries as the publication has 25 tables.

  I have been setting up replication since SQL 2000, thus am not a novice at replication. I have never had this happen to me before.

  Has anyone seen this happen? Is it a new thing in SQL Server 2012 that I am not aware of perhaps?

  Publisher details:

  OS: Windows Server 2012

  SQL: SQL Server 2012 ENT

  Distributor:

  OS: Windows Server 2012

  SQL: SQL Server 2012 STD

  Subscriber details:

  OS: Windows Server 2008 R2

  SQL: SQL Server 2008 R2 ENT

  Regards,

  TDP

  runstatustimedurationcomments

  22013-11-07 16:391523Executed as user: DOMAIN\SQLReplication. The step was cancelled (stopped) as the result of a stop job request.

  32013-11-07 16:361291Delivered snapshot from the 'unc\SERVER_PUBLICATIONNAME\20131107144443\' sub-folder in 1290734 milliseconds

  32013-11-07 16:361291Creating Primary Key index on table '[dbo].[tb_ExternalBonusBalanceLogAdminEvent]'

  32013-11-07 16:361287Creating Primary Key index on table '[dbo].[tb_ExternalBonusBalanceLog]'

  32013-11-07 16:331132Bulk copied data into table 'tb_ExternalProduct' (4 rows)

  32013-11-07 16:331132Bulk copying data into table 'tb_ExternalProduct'

  32013-11-07 16:331129Bulk copied data into table 'tb_ExternalBonusBalanceLogAdminEvent' (3139761 rows)

  32013-11-07 16:331123Bulk copying data into table 'tb_ExternalBonusBalanceLogAdminEvent'

  32013-11-07 16:331118Bulk copied data into table 'tb_ExternalBonusBalanceLog' (16437119 rows)

  32013-11-07 16:26688Bulk copying data into table 'tb_ExternalBonusBalanceLog'

  32013-11-07 16:144Applied script 'tb_ExternalProduct_26.sch'

  32013-11-07 16:143Applied script 'tb_ExternalBonu2b1b331b_25.sch'

  32013-11-07 16:142Applied script 'tb_ExternalBonud8b44098_24.sch'

  32013-11-07 16:140Applied script 'tb_ExternalBonud8b44098_24.pre'

  32013-11-07 16:140Applied script 'tb_ExternalBonu2b1b331b_25.pre'

  32013-11-07 16:140Applied script 'tb_ExternalProduct_26.pre'

  12013-11-07 16:140Initializing

  32013-11-07 16:132251Delivering replicated transactions

  62013-11-07 16:102065The replication agent has not logged a progress message in 10 minutes.

  32013-11-07 15:561241Delivered snapshot from the 'unc\SERVERNAME_PUBLICATIONNAME\20131107144443\' sub-folder in 1240609 milliseconds

  32013-11-07 15:561241Creating Primary Key index on table '[dbo].[tb_ExternalBonusBalanceLogAdminEvent]'

  32013-11-07 15:561236Creating Primary Key index on table '[dbo].[tb_ExternalBonusBalanceLog]'

  32013-11-07 15:46674Bulk copied data into table 'tb_ExternalProduct' (4 rows)

  32013-11-07 15:46674Bulk copying data into table 'tb_ExternalProduct'

  32013-11-07 15:46671Bulk copied data into table 'tb_ExternalBonusBalanceLogAdminEvent' (3139761 rows)

  32013-11-07 15:46665Bulk copying data into table 'tb_ExternalBonusBalanceLogAdminEvent'

  32013-11-07 15:46661Bulk copied data into table 'tb_ExternalBonusBalanceLog' (16437119 rows)

  32013-11-07 15:44536Bulk copying data into table 'tb_ExternalBonusBalanceLog'

  32013-11-07 15:353Applied script 'tb_ExternalProduct_26.sch'

  32013-11-07 15:353Applied script 'tb_ExternalBonu2b1b331b_25.sch'

  32013-11-07 15:353Applied script 'tb_ExternalBonud8b44098_24.sch'

  32013-11-07 15:350Applied script 'tb_ExternalBonud8b44098_24.pre'

  32013-11-07 15:350Applied script 'tb_ExternalBonu2b1b331b_25.pre'

  32013-11-07 15:350Applied script 'tb_ExternalProduct_26.pre'

  12013-11-07 15:350Initializing

  32013-11-07 15:342872Delivering replicated transactions

  32013-11-07 15:191979Delivered snapshot from the 'unc\SERVERNAME_PUBLISHERNAME\20131107144443\' sub-folder in 1413954 milliseconds

  32013-11-07 15:191979Creating Primary Key index on table '[dbo].[tb_ExternalBonusBalanceLogAdminEvent]'

  32013-11-07 15:181896Creating Primary Key index on table '[dbo].[tb_ExternalBonusBalanceLog]'

  32013-11-07 15:131623Bulk copied data into table 'tb_ExternalProduct' (4 rows)

  32013-11-07 15:131623Bulk copying data into table 'tb_ExternalProduct'

  32013-11-07 15:131620Bulk copied data into table 'tb_ExternalBonusBalanceLogAdminEvent' (3139761 rows)

  32013-11-07 15:131615Bulk copying data into table 'tb_ExternalBonusBalanceLogAdminEvent'

  32013-11-07 15:131610Bulk copied data into table 'tb_ExternalBonusBalanceLog' (16437119 rows)

  32013-11-07 15:131610Bulk copying data into table 'tb_ExternalBonusBalanceLog'

  32013-11-07 14:56578Applied script 'tb_ExternalProduct_26.sch'

  32013-11-07 14:56577Applied script 'tb_ExternalBonu2b1b331b_25.sch'

  32013-11-07 14:56577Applied script 'tb_ExternalBonud8b44098_24.sch'

  32013-11-07 14:55565Applied script 'tb_ExternalBonud8b44098_24.pre'

  32013-11-07 14:55565Applied script 'tb_ExternalBonu2b1b331b_25.pre'

  32013-11-07 14:55565Applied script 'tb_ExternalProduct_26.pre'

  12013-11-07 14:460Initializing