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.
| 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 stepAny help will be appreciatedThanksExperts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 18:14:39
|
| No you can't unless has separate publication. |
 |
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
|
|
|
Create snapshot for remaining tables