adding a new subscriber

Hi
I have merge replication. One client is already subscribed. I need to add
another client to the publication
The database is pretty big, so I don't want to send the whole db over the
internet.
I want to back it up and restore it, then establish the subscription.
Are the steps
a) backup database
b) recreate snapshot
c) restored db at subcriber B
d) establish subscription at subcriber B
I would assume I don't want any changes to the database made from the other
subscriber between steps a) and d)
Is this right. And I hope recreating the snapshot will not 'damage'
subscriber A
Thanks
Bruce
Thanks
Bruce
Bruce,
if you want a pull subscription, the easiest way is to create an Attachable
Subscription Database (details in BOL). If not, then you can backup and
restore and subscribe without initialization - @.sync_type = none.
HTH,
Paul Ibison
|||Bear in mind that if the database is too large the attachable subscription
will not work. The compressed databse is limited to 2 gig in size so a
large database will have problems.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Add Disclaimer Text to the RS report Subscription

I want to know , how to add Company Disclaimer text whenever Report is
Subscribed for Email. Either directly From Report Manager subscription / using
Create Subscription Web Methods. I don't want to put it as Report Footer.
Thanks!Hi,
It is not possible to put it in the email. Moreover you dont wont it in the
report as well. So no way, probabily you can think off at mail server end
again it will be difficult to identify each and every mail for the report. :-(
Just an idea. Its a very round about method and dont think it is advisable.
You need to write a small utility to pick up mails from the mailbox of the
server which should not have the gateway. If you dont give the gateway, what
happens is that the mails in .eml format will be at outbox at
inetpub\mailroot. your utility should pick these mails and send it through a
gateway. while sending it you may add the disclaimer.
I have not tried on adding something. But I have done this utility to pick
this mails and send it via other SMTP.
Amarnath
"RAGHAVAN JAYARAMAN" wrote:
> I want to know , how to add Company Disclaimer text whenever Report is
> Subscribed for Email. Either directly From Report Manager subscription / using
> Create Subscription Web Methods. I don't want to put it as Report Footer.
> Thanks!|||Thanks Amarnath.What if i want to add a disclaimer as Page Footer and want to
show it for only Report subscription (Email /MHTML ) or may be enable through
hidden parameter which sets to show & hide footer.
"Amarnath" wrote:
> Hi,
> It is not possible to put it in the email. Moreover you dont wont it in the
> report as well. So no way, probabily you can think off at mail server end
> again it will be difficult to identify each and every mail for the report. :-(
> Just an idea. Its a very round about method and dont think it is advisable.
> You need to write a small utility to pick up mails from the mailbox of the
> server which should not have the gateway. If you dont give the gateway, what
> happens is that the mails in .eml format will be at outbox at
> inetpub\mailroot. your utility should pick these mails and send it through a
> gateway. while sending it you may add the disclaimer.
> I have not tried on adding something. But I have done this utility to pick
> this mails and send it via other SMTP.
> Amarnath
>
> "RAGHAVAN JAYARAMAN" wrote:
> > I want to know , how to add Company Disclaimer text whenever Report is
> > Subscribed for Email. Either directly From Report Manager subscription / using
> > Create Subscription Web Methods. I don't want to put it as Report Footer.
> >
> > Thanks!|||Hi,
Thats the solution I thought first, but you had given that email should have
disclaimer and not on the report.
Again. You can do what you have mentioned but not in email. Other solution
also I thought of but didn't post it because it is something to do with
manipulating the report server tables.
It goes like this.
As you know that "catalog" table keeps report info and "subscription" has
subscription what you can do is to check any report has an entry in the
subscription table with ID from catalog. If exists then check for delivery
extension if it is email then enable the footer other wise no.
something like that . But haven;t tried.
Amarnath.
"RAGHAVAN JAYARAMAN" wrote:
> Thanks Amarnath.What if i want to add a disclaimer as Page Footer and want to
> show it for only Report subscription (Email /MHTML ) or may be enable through
> hidden parameter which sets to show & hide footer.
> "Amarnath" wrote:
> > Hi,
> >
> > It is not possible to put it in the email. Moreover you dont wont it in the
> > report as well. So no way, probabily you can think off at mail server end
> > again it will be difficult to identify each and every mail for the report. :-(
> >
> > Just an idea. Its a very round about method and dont think it is advisable.
> >
> > You need to write a small utility to pick up mails from the mailbox of the
> > server which should not have the gateway. If you dont give the gateway, what
> > happens is that the mails in .eml format will be at outbox at
> > inetpub\mailroot. your utility should pick these mails and send it through a
> > gateway. while sending it you may add the disclaimer.
> >
> > I have not tried on adding something. But I have done this utility to pick
> > this mails and send it via other SMTP.
> >
> > Amarnath
> >
> >
> > "RAGHAVAN JAYARAMAN" wrote:
> >
> > > I want to know , how to add Company Disclaimer text whenever Report is
> > > Subscribed for Email. Either directly From Report Manager subscription / using
> > > Create Subscription Web Methods. I don't want to put it as Report Footer.
> > >
> > > Thanks!