Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Create snapshot for remaining tables

Author  Topic 

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-01-21 : 17:27:59
I have already created Tran. Replication for one database and it is working fine. But i have added 3 tables to the database and i want to do replication for that tables with same publications . I mean i can go to Publishers Properties and add articles but the problem is:
1)When i run the snapshot agent,it creates the snapshot whole database which is bigger in size .
2)Is there a way i can run snapshot agent for remaining articles in same publication.
3)How to do it step by step

Any help will be appreciated
Thanks
Experts

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-21 : 18:14:39
No you can't unless has separate publication.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-01-31 : 16:39:00
Yes rmaio, It is supported in SQL Server 2005 and even DDL changes as well. Well, it is supported in SQL server 2000 too but you have to change article properties.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-31 : 23:47:09
It's only possible if has separate snapshot agent, that's what I mean.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-01 : 11:54:15
No, it works with same Snapshot also.When you run snapshot again, It will create only for the remaining one.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-01 : 22:57:52
Just tried that week ago, never work. Opened case with Microsoft and they can't figure out, I ended up with reconfiguring replication completely.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-02 : 16:01:12
It worked for me in SQL server 2005 standard edition.
Go to Top of Page
   

- Advertisement -