December 12, 2005 at 8:10 am
Seems like I should know this, but ........
I have a Transactional Publication with 2 very large tables. I want to add a small 3rd table to this publication, but don't want to have to re-snapshot and push the 2 large tables. I can add the small table to the publication, but is there any way to get the small one to start replicating without re-snapshotting and pushing the other tables ?
December 13, 2005 at 6:36 am
use tsql to add the table, refresh and run the snapshot job - ( it should ) does for me only refresh the new object.
you need
exec dbo.sp_addarticle
sp_refreshsubscriptions
then
exec msdb.dbo.sp_start_job @job_name { = snapshot job name }
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 13, 2005 at 8:14 am
That will still create snapshots for the other tables, right ? So I need to do it in off hours to prevent locks on those tables, even though they won't get sent to the subscriber. I added the new table through the Publication GUI, but didn't run the snapshot job yet.
December 13, 2005 at 9:34 am
no, it does not create snapshots for all tables. It creates a snapshot for only the table that you added as mentioned by Colin.
Tejas.
December 13, 2005 at 2:43 pm
Thanks .. That sounds right ........... unless I mistakenly select "reinitialize", then I think it will re-snapshot all the tables.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply