November 14, 2003 at 10:19 am
Hi,
I need to add some new tables for SQL2K replication, and would like to know where there are any ways to do it without breaking the current replication.
Thanks in advance.
John
November 17, 2003 at 8:00 am
This was removed by the editor as SPAM
November 17, 2003 at 9:08 am
Looks like I can use sp_addarticle.
November 17, 2003 at 1:40 pm
You should be able to add it through Enterprise Manager ...... That's how I do it.
November 17, 2003 at 6:19 pm
I will try it!
Thanks.
November 17, 2003 at 6:36 pm
Before adding a table I would make sure that you have all your subscriptions sync up. Then add the table. The reason for this is that you will have to reinitialize the subscriptions and this way if you encounter problems you can restore the subscriptions/publication to a known state.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
November 18, 2003 at 8:27 am
Thanks for your advice, Gary!
November 19, 2003 at 6:33 am
I typically create a new publication. Then at some point in the future when I have time, I may put them all back into one. Can't add an article if you have any subscribers, which means you have to remove them all, make the change, then resnapshot (though you can finesse this part).
Andy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply