Replication Remove artilce that failed to publish - 2012 to 2014

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 26, 2015 at 12:27 pm

  #318515

  I have a table with Time Data Type Fields.

  If I try to remove the failed article I get a message that I would need to create a new Snapshot.

  I removed the Article and generated a snapshot.

  I was wondering what other task I need to do?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 26, 2015 at 1:00 pm

  #1808510

  I appears that all I have to do is remove the article and then generate snapshot?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 29, 2015 at 6:24 am

  #1808726

  I have to synchronize the snapshot.

  Microsoft says to do the following:

  1.In Replication Monitor, expand a Publisher group in the left pane, expand a Publisher, and then click a publication.

  2.Click the All Subscriptions tab.

  3.Right-click the subscription you want to synchronize, and then click Start Synchronizing.

  4.To view synchronization progress, right-click the subscription, and then click View Details

  I'm trying but I can't get to the screen to Start Synchronizing?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  June 29, 2015 at 6:38 am

  #1808733

  Hello Welsh,

  You can do the same with the executing jobs. Refer follwoing link for further details:

  https://msdn.microsoft.com/en-us/library/ms151783(v=sql.110).aspx

  HTH

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."