| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2008-07-07 : 17:22:00
|
| Hi All,I have an existing publication and I want to add one table to it, without regenerating snapshot for all the article. I read in some article that I should use "sp_changearticle" after adding table to the publisher. But dont know how to use it.Also checked BOL but nothing much clear from there.Can anybdy help? I am using SQL server 2005 with SP2.RegardsSachin |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-07 : 18:03:13
|
| In SQL 2005, It creates only snapshot for the added article. Make sure you add article and start snapshot agent. you should be good. |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-07-08 : 00:54:53
|
| Thanks Sodeep,I have added the article and now its showing synchronization status as "The snapshot for table1 is not yet generated.". How can I start snapshotagent?Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 13:29:09
|
| Goto Publisher properties and enable snapshot agent. |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-07-08 : 14:56:53
|
| I am sorry sodeep, I didnt got this option.Can you please elaborate how can I achive this, without regenerating the entire snapshot from scratch?Thanks in advance.Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 14:59:25
|
| Right click you Publication- Properties - Choose Snapshot agent -start it after you add articles. |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-07-08 : 22:43:15
|
| I am using SQL Server 2005.When I right click publication and go to properties, I see tabs with name General, Article, Filter row, Snapshot, FTPSnapshot, Subscription Option, Publication Access List, and Agent Security.Am I on the right screen?I cannot see any option to start snapshot agent.Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 22:48:16
|
| Right click Publisher-View snapshot agent-start it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-08 : 23:30:11
|
| Or start it in replication monitor. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-09 : 13:03:17
|
| Or use this system procedure:EXEC sp_startpublication_snapshot @publication = 'yourpublication' |
|
|
|
|
Adding table to existing publisher?