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 |
|
maximus_vj
Yak Posting Veteran
88 Posts |
 Posted - 2007-01-30 : 14:25:06
|
| Hello,Currently I have "Transactional Replication" going. I have a publisher, distributor and a subcriber (configured on different servers). And we are using PUSH subscription.All the changes to the database are done in the Publisher only.This is working well for us.I want to find out if I can do the following:1) Can I add another subscriber to this setup. So I will have one publisher and 2 subscribers.2) If yes, can I add the new subscriber without disturbing the current set up. By this I mean do I have to re-configure the whole replication with 2 subscribers.Please advice.Thanksmaximus_vj |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-30 : 14:51:03
|
| 1. Yes.2. Just add another subscription.Tara Kizer |
 |
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2007-02-06 : 18:28:21
|
| Hi Tara,Thanks for the response.To add a new Subscriber to my existing Replication Setup:Do I have to delete the replication and start the Setup from scratch?Is there any way I can just add the new subscriber without configuring the replication from scratch?It will be great if you can point me to resources which have this information.Thanksmaximus_vj |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-06 : 18:31:22
|
No you don't need to set it up from scratch. I don't have any resources to point you to. Everything I know about replication has been learned from another DBA here and is now stored in my mind. Directions to my mind usually require diamonds.  Tara Kizer |
|
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2007-02-13 : 13:48:02
|
| Hi Tara,I figured out how to add a new Subscriber to my transactional replication without disturbing the current setup.But I have two followup questions:Can the distribution agents for these two subscribers be on different schedules?The reason I ask this is lets say we made some changes to the publisher. Lets say Distribution Agent 1 (DA1) for Subscriber 1(S1) runs after 10 mins and the Distribution Agent 2 (DA2) for Subscriber 2 (S2)runs after 15 mins. If I assume that transactional replication uses "Transaction Log Backups" internally then all the transactions in the log are not available for the second Subscriber.If the Transactional Replication doesn't do Transactional Log backups, then does creating a Transactional Log Backup job on Publisher causes any issues with Transactional replication?Thanks for your help,Vijay |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-13 : 14:02:47
|
| Transactional replication has nothing to do with transaction log backups. You need to perform backups on both databases.I don't remember if each subscriber gets its own job. So you'll need to check on that to determine if they can run on different schedules.Tara Kizer |
|
|
|
maximus_vj
Yak Posting Veteran
88 Posts |
Posted - 2007-02-13 : 16:04:50
|
Thanks Tara for the info.quote:
Originally posted by tkizerI don't remember if each subscriber gets its own job. So you'll need to check on that to determine if they can run on different schedules.
Yes each Subscriber gets its own job.Thanksmaximus_vj |
|
|
|
|
|
|
Adding a new Subscriber - Replication