Adding new article to existing publication

Question

Adding new article to existing publication

Viewing 4 posts - 16 through 18 (of 18 total)

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

JeremyE SSCoach Points: 16199 More actions · Answer 1

Welsh Corgi (10/5/2015)
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 and allow_anonymous
This article explains it well: https://www.mssqltips.com/sqlservertip/2502/limit-snapshot-size-when-adding-new-article-to-sql-server-replication/[/url]
Where do you specify that?
I could not find it in the article.
Thank you.

It's in the article.

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

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

How do I correct this. No backup.

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/

Michael L John One Orange Chip Points: 27055 More actions · Answer 3

Why don't you just create a new publication for the new articles? Leave the existing one alone.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

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

I was looking in the wrong DB for the file.

I was able to add 1 article that I needed and I'm set to add over 1,00 plus. 600 SP' plus their associated objrcts.

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/