SQL Server Performance

Adding new tables to the existing replication

Discussion in 'SQL Server 2005 Replication' started by gopal, May 19, 2008.

  1. gopal Member

    I am using SQL 2005 Replication. I have the replication already setup with 5 tables. I wanted to add 2 more tables (with 20 million rows) to the existing replication. My question is:
    1. Is it possible to initialize the subscriber with only the 2 tables added? I don't wanted to reinitialize the existing 5 tables.
    2. Is there any other way to initialize the subscriber without impacting the performance on the publisher?
    Any suggestions is much appreciated.
    Thank in advance.
  2. MohammedU New Member

Share This Page