Replication Remove artilce that failed to publish - 2012 to 2014

Question

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/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

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 · Answer 2

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: 27169 More actions · Answer 3

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."