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 |
|
pontifikas
Starting Member
32 Posts |
 Posted - 2004-09-29 : 08:01:30
|
I have a transactional replication with qeued updating and updating subscribers.I have 2 questions,which may sound silly but are of outmost imprtance to me.1)Should for a reason the distribution agent not be able to communicate with the subscriber for 2 days, will the changes made in the publisher be delivered to the subscriber as soon as the connection is established again, or do I have to run the snapshot agents?2)Should I want to add a table to the publisher or a new column to some table ,publish stored procedures etc, the documentation says I have to disable the publishing.If I do so, and re-establish the subscriptions, do I have to create the subscribers database from scratch or will the new items be added automatically to the existing database?Thanks in advance |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-01 : 03:36:16
|
| 1) there is a setting for each publication wherein replication that remain inactive for a certain period of time need to be reinitialized (snapshot to be generated again), but if 2 days is below that time, just synchronize.2) if you're adding a new column, no need to recreate publication, just issue the sp_repladdcolumn, and only the snapshot for the affected table will be generated. for new articles use sp_addarticle. |
 |
|
|
|
|
|
Transactional Issues