SQL Server Performance

Adding article to the existing replication

Discussion in 'General DBA Questions' started by preethi, Feb 10, 2005.

  1. preethi Member

    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
  2. satya Moderator

  3. preethi Member

    sp3a. I do have all the hotfixes too.

    Cheers,
    Preethiviraj Kulasingham
  4. satya Moderator

    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.
  5. preethi Member

    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
  6. satya Moderator

    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.
  7. preethi Member

    Thank you, let me try with a new publication.

    Thanks again for your support.


    Cheers,
    Preethiviraj Kulasingham

Share This Page