I have 1 Publisher Server that uses itself as the distributor for 3
different publications.
The publications are all transactional and all publications use Push
subscriptions to replicate their articles.
I have 2 Subscriber servers. Each subscriber server receives 3 push
subscriptions, 1 from each of publications of the Publisher Server.
My Question is can I have different Distribution Agent Schedules for each of
the different publications?
In other words, can publication_1 can be distributed with a schedule of 1
try every day, publication_2 with a schedule of 2 tries evey day and
publication_3 with a constant (inmediate) distribution shedule?
I have tried tihs, when I create the push subscriptions I specify diffrent
schedules for each subscription but when I look in the Agents folder under
Distribution Agents I can only find an entry that says
'multiple-publications' and only has One Schedule.
In contrast under SnapShot Agents there are one entry for each of the
publications, each with a schedule.
Thanks for any help or info.
You sure can, however you need to use the independent_agent option on your
publication.
sp_changepublication 'publicationName','independent_option','true'
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Adrian320" <Adrian320@.discussions.microsoft.com> wrote in message
news:06C20D17-F2BA-4AE9-BF42-C019A5DBDDEB@.microsoft.com...
> I have 1 Publisher Server that uses itself as the distributor for 3
> different publications.
> The publications are all transactional and all publications use Push
> subscriptions to replicate their articles.
> I have 2 Subscriber servers. Each subscriber server receives 3 push
> subscriptions, 1 from each of publications of the Publisher Server.
> My Question is can I have different Distribution Agent Schedules for each
of
> the different publications?
> In other words, can publication_1 can be distributed with a schedule of 1
> try every day, publication_2 with a schedule of 2 tries evey day and
> publication_3 with a constant (inmediate) distribution shedule?
> I have tried tihs, when I create the push subscriptions I specify diffrent
> schedules for each subscription but when I look in the Agents folder under
> Distribution Agents I can only find an entry that says
> 'multiple-publications' and only has One Schedule.
> In contrast under SnapShot Agents there are one entry for each of the
> publications, each with a schedule.
> Thanks for any help or info.
|||Thanks, I'll try that right away.
Just out of curiosity is that parameter asked in the publication wizard, by
any chance?
"Hilary Cotter" wrote:
> You sure can, however you need to use the independent_agent option on your
> publication.
> sp_changepublication 'publicationName','independent_option','true'
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Adrian320" <Adrian320@.discussions.microsoft.com> wrote in message
> news:06C20D17-F2BA-4AE9-BF42-C019A5DBDDEB@.microsoft.com...
> of
>
>
|||I have never tried it, but I assumed you could create different schedules
for each of the subscriptions under the publication.
Does it not work ? Do they all run in continuous mode ?
"Adrian320" <Adrian320@.discussions.microsoft.com> wrote in message
news:06C20D17-F2BA-4AE9-BF42-C019A5DBDDEB@.microsoft.com...
> I have 1 Publisher Server that uses itself as the distributor for 3
> different publications.
> The publications are all transactional and all publications use Push
> subscriptions to replicate their articles.
> I have 2 Subscriber servers. Each subscriber server receives 3 push
> subscriptions, 1 from each of publications of the Publisher Server.
> My Question is can I have different Distribution Agent Schedules for each
of
> the different publications?
> In other words, can publication_1 can be distributed with a schedule of 1
> try every day, publication_2 with a schedule of 2 tries evey day and
> publication_3 with a constant (inmediate) distribution shedule?
> I have tried tihs, when I create the push subscriptions I specify diffrent
> schedules for each subscription but when I look in the Agents folder under
> Distribution Agents I can only find an entry that says
> 'multiple-publications' and only has One Schedule.
> In contrast under SnapShot Agents there are one entry for each of the
> publications, each with a schedule.
> Thanks for any help or info.
|||with the parameter Hilary said, yes it works. Without it you have only one
schecule for each subscriber/publication, helas you can't have without the
parameter activated varios schedules for the same subscriber in differente
publications.
Adrian
"Hassan" wrote:
> I have never tried it, but I assumed you could create different schedules
> for each of the subscriptions under the publication.
> Does it not work ? Do they all run in continuous mode ?
> "Adrian320" <Adrian320@.discussions.microsoft.com> wrote in message
> news:06C20D17-F2BA-4AE9-BF42-C019A5DBDDEB@.microsoft.com...
> of
>
>
|||Now my heads hurting..
Can you give me an example..
Say in your case we have Publisher1 and Subscriber1,Subscriber2 and
Subscriber3
You have 2 publications Pub1 and Pub2
Pub1 has 3 subscriptions to the 3 subscribers
and Pub2 has 3 subscriptions to the 3 subscribers
So if i go to each of the subscriptions for Pub1, can I not create seperate
schedules for the distribution agent ? Or am I not following something
Please use the example and help me understand.
"Adrian320" <Adrian320@.discussions.microsoft.com> wrote in message
news:E90BCEA8-CED8-428E-BF92-9A440E23FD66@.microsoft.com...[vbcol=seagreen]
> with the parameter Hilary said, yes it works. Without it you have only one
> schecule for each subscriber/publication, helas you can't have without the
> parameter activated varios schedules for the same subscriber in differente
> publications.
> Adrian
> "Hassan" wrote:
schedules[vbcol=seagreen]
each[vbcol=seagreen]
of 1[vbcol=seagreen]
diffrent[vbcol=seagreen]
under[vbcol=seagreen]
|||no, but it does show up in your publication properties in the subscription
options tab. Chances are however you will need to use sp_changepublication
to enable it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Adrian320" <Adrian320@.discussions.microsoft.com> wrote in message
news:8A96C8B2-0FF9-47E6-B4CE-6FB0B12D2273@.microsoft.com...
> Thanks, I'll try that right away.
> Just out of curiosity is that parameter asked in the publication wizard,
by[vbcol=seagreen]
> any chance?
> "Hilary Cotter" wrote:
your[vbcol=seagreen]
each[vbcol=seagreen]
of 1[vbcol=seagreen]
diffrent[vbcol=seagreen]
under[vbcol=seagreen]
|||No, if pubs and pub2 are in the same publication database, there will be a
single distribution agent by default, going to each subscriber. What
replication will do is share an agent for the same type from the same
publication database to the same subscription database.
With the shared agent, there can be no different schedules. With the
independent agent option you can set multiple schedules.
HTH
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u23zm$48EHA.2452@.TK2MSFTNGP14.phx.gbl...
> Now my heads hurting..
> Can you give me an example..
> Say in your case we have Publisher1 and Subscriber1,Subscriber2 and
> Subscriber3
> You have 2 publications Pub1 and Pub2
> Pub1 has 3 subscriptions to the 3 subscribers
> and Pub2 has 3 subscriptions to the 3 subscribers
> So if i go to each of the subscriptions for Pub1, can I not create
seperate[vbcol=seagreen]
> schedules for the distribution agent ? Or am I not following something
> Please use the example and help me understand.
> "Adrian320" <Adrian320@.discussions.microsoft.com> wrote in message
> news:E90BCEA8-CED8-428E-BF92-9A440E23FD66@.microsoft.com...
one[vbcol=seagreen]
the[vbcol=seagreen]
differente[vbcol=seagreen]
> schedules
> each
> of 1
> diffrent
> under
the
>
