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: Is it possible to initialize the subscriber with only the 2 tables added? I don't wanted to reinitialize the existing 5 tables. Is there any other way to initialize the subscriber without impacting the performance on the publisher? Any suggestions is much appreciated. Thank in advance.
Check the following thread...it has the answer for you.... http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2140692&SiteID=1&mode=1