How can you get an Alter that replication is not refreshing the subscriber?

Is there a 3rd party tool to do this?

I created an alter in SSMS but it did not...

Lynn Pettis (10/5/2015)

---

And we would have...

I was looking for the syspublications table in the wrong table.

I added the article without incident.

syspublications table is empty in the Distribution DB and does not exist in Master DB.

How do I correct this. No backup.

Someone removed the article.

JeremyE (10/2/2015)

---

There are 2 options that need to be set to false for the publication in order to add an article and only snapshot that article vs the entire publication.

immediate_sync...

stakes (12/9/2010)

---

Got the solution!

To get the Alert working, you should leave the Type to 'SQL Server event alert', database name to <all databases> and the error number to 14161....

winash (10/6/2010)

---

The snapshot will be generated for all articles being replicated (i.e. all the existing articles plus any new articles being added to the publication) - however the distribution agent...

winash (10/6/2010)

---

Adding/Dropping articles from existing publications: http://technet.microsoft.com/en-us/library/ms152493(SQL.90).aspx

When you are generating the snapshot you will be able to access both the publisher and subscriber - from what I remember the snapshot...

I had to replace my keyboard.

I'm going from SQL Server 20122 Enterprise to SQL Server 2014 Enterprise.

If you add multiple articles do you have to perform a full Snapshot?

I did a couple of backups from the GUI and it named the file with a trn extension.

I'm replicating from 3023R2 to 2914.

Is it possible to add more than 1 article at a time without having to do a full snapshot?

I did it before and had nixed results.

GilaMonster (10/2/2015)

---

You can't back up TempDB and shrinking it is pointless if there's a process which uses a lot of TempDB, it'll just grow again. It's like complaining that the...

JeremyE (10/2/2015)

---

There are 2 options that need to be set to false for the publication in order to add an article and only snapshot that article vs the entire publication.

immediate_sync...