SQL Server Performance Forum – Threads Archive

Adding article to the existing replication

Hi All, I have a server where replication is set up between 2 differnt databases. It is currently running. I want to add a couple of tables to the replication. I tried using sp_addArticle. In the properties of the replication it shows the new tables, but at the database level the tables are missing. I tried with sp_addsubscription but I am getting strange error: Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240
Specify all articles when subscribing to a publication using concurrent snapshot processing. What can I do to publish the tables into the target database?
Thanks in advance. Cheers,
Preethiviraj Kulasingham

What is the level of service pack on SQL? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

sp3a. I do have all the hotfixes too. Cheers,
Preethiviraj Kulasingham

So, that means, there’s no point in adding an article to an existing publication (that is setup with concurrent snapshot option), as you cannot synchronize subscriptions for those publications, without a complete resynch. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Satya,
Thank you for your continuous support in this topic.
Then How can I add tables?
Do I have to have another publication for the new tables?
(I DO NOT want to re-create the same publication with additional tables, as snapshot replication will take a long time to re-populate the millions of records.)
thanks in advance,
Cheers,
Preethiviraj Kulasingham

Preethvi I’ve tried to reproduce the error at my end, but no issues. As I was able to add new tables whenever I want. So I believe for a intermittent fix you may need to refresh the publication with additional tables and if you feel it will tabke more time to process then you can have another publication. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thank you, let me try with a new publication. Thanks again for your support.
Cheers,
Preethiviraj Kulasingham

]]>