Copying inicial snapshot to the subscriber via CD

Hi!
I have a very large database that I replicate to 40 subscribers. The problem is that where I make a new push subscription and SQL is applying the Msmerge_contens, I obtain the message "The subscriber didn't respond in 10 minutes. Agent is suspect." I have
already increment de 10 minutes to 2 hours but the problem continues to exist. How can I put the snapshot in the subscriber via CD in order to avoid all then data transference over a slow network?
Regards
This message does not mean that your snapshot will not be applied
successfuly, it just means that it takes more than 10 minutes to transfer
some article data. This status of merge agent looks like an error (in EM),
but it is not. Just check if the merge agent job is runing - if it is, then
everything is fine, it just takes time..
If you want to avoid copying all the data to subscribers you can make a
backup of your publisher and restore it in remote location. Then create
subscription in such a way, that it would not synchronize data - after
restore data is identical anyway. But doing it in such a way you have to
make sure that during the interval between publisher backup and restore on
subscriber, no data changes are made on publisher.
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Pedro" <pedro.lopes@.sqps.ivn.pt> wrote in message
news:C7D02833-9B35-4798-94F2-9B6FDED8808D@.microsoft.com...
> Hi!
> I have a very large database that I replicate to 40 subscribers. The
problem is that where I make a new push subscription and SQL is applying the
Msmerge_contens, I obtain the message "The subscriber didn't respond in 10
minutes. Agent is suspect." I have already increment de 10 minutes to 2
hours but the problem continues to exist. How can I put the snapshot in the
subscriber via CD in order to avoid all then data transference over a slow
network?
> Regards
>

copying a subscription

I need to create 3 very similar data-driven subscriptions, with minor changes
in report parameters, and differences in the 3 schedules.
I there a way I can "copy-paste" one subscription into another? Is there a
subscription description language kind of like RDL that I could duplicate?
Any suggestions?
tia.Hi,
From your descriptions, I understood that you would like to use one
subscrition as 'model' and then 'paste' them for other two. Have I
understood you? Correct me if I was wrong.
Based on my scope, unfortuantely, I am afraid you will have to setup the
subscription separately.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Your answer was all I needed, thanks.
I thought clicking "Was this post helpful to you?" was enough to let you know.
""Michael Cheng [MSFT]"" wrote:
> Hi,
> I wanted to post a quick note to see if you would like additional
> assistance or information regarding this particular issue. We appreciate
> your patience and look forward to hearing from you!
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi,
Thanks for your prompt updates!
Unfortuantely, the result of clicking "Was this post helpful to you?" was
not submitted to me, it was used for another use:(, might be for feedback
collection.
Anyway, it is highly appreciated for your kindest reply letting me know
this, thanks once more. Whenever you have any questions or concerns, don't
hesitate to let me know. We are always here to be of assistance!
Have a good day!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||The easiest way would be to use the SOAP methods. You could call
GetDataDrivenSubscriptionProperties and then call
CreateDataDrivenSubscription with the result. You would have to reenter
data source credentials as these are not returned via SOAP.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"James" <news@.att.com> wrote in message
news:B641549F-FDAA-4068-A5AA-46BF36C64CC5@.microsoft.com...
>I need to create 3 very similar data-driven subscriptions, with minor
>changes
> in report parameters, and differences in the 3 schedules.
> I there a way I can "copy-paste" one subscription into another? Is there a
> subscription description language kind of like RDL that I could duplicate?
> Any suggestions?
> tia.

Copy subscription fails

I understand that there is a limitation in windows for compressing 2gb +. I
am trying to create an msf by "copying a subscription". As an alternative
method I have tried to copy the subscription database using the "copy
database" wizard it gives me an error that is supposedly suppost to be a
permissions problem. Has anyone in the group been able to figure out where
the permissions are to be set to copy a database between two servers. I've
already tried the domain administrator in which both machines are members
of.
there error you are probably getting is because an account or dbuser is not
present in the target database.
repeat the copy and post back here with the exact error message you are
getting.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Sam" <sam@.info.com> wrote in message
news:10f89dua28ama86@.corp.supernews.com...
> I understand that there is a limitation in windows for compressing 2gb +.
I
> am trying to create an msf by "copying a subscription". As an alternative
> method I have tried to copy the subscription database using the "copy
> database" wizard it gives me an error that is supposedly suppost to be a
> permissions problem. Has anyone in the group been able to figure out where
> the permissions are to be set to copy a database between two servers.
I've
> already tried the domain administrator in which both machines are members
> of.
>
|||I figured out how to copy a database. Thank you for your help. But the
original issue was to avoid using the copy subscription method which is
limited to 2gb. The copy database wizard does not allow me to copy a
replication database. How do I get a subscription on another machine without
using snapshot folders. I loved the msf files because you can manage it
easily with novice users but like I said before it has a 2gb limit. What is
the simplest way to move the subscriptions without a snapshot folder (merge
replication)?
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uIpE6MRaEHA.3112@.tk2msftngp13.phx.gbl...
> there error you are probably getting is because an account or dbuser is
not[vbcol=seagreen]
> present in the target database.
> repeat the copy and post back here with the exact error message you are
> getting.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Sam" <sam@.info.com> wrote in message
> news:10f89dua28ama86@.corp.supernews.com...
+.[vbcol=seagreen]
> I
alternative[vbcol=seagreen]
where[vbcol=seagreen]
> I've
members
>
|||back up the publication database, copy the backup file to the subscriber and
restore it there. Then do a nosync subscribption.
A small snapshot will be generated and distributed to your subscription with
procs, triggers, and metadata merge needs to work.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Sam" <sam@.info.com> wrote in message
news:10faqndd1576a3d@.corp.supernews.com...
> I figured out how to copy a database. Thank you for your help. But the
> original issue was to avoid using the copy subscription method which is
> limited to 2gb. The copy database wizard does not allow me to copy a
> replication database. How do I get a subscription on another machine
without
> using snapshot folders. I loved the msf files because you can manage it
> easily with novice users but like I said before it has a 2gb limit. What
is
> the simplest way to move the subscriptions without a snapshot folder
(merge[vbcol=seagreen]
> replication)?
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:uIpE6MRaEHA.3112@.tk2msftngp13.phx.gbl...
> not
> +.
> alternative
a[vbcol=seagreen]
> where

> members
>
|||I tried what you've told me and it worked great so far. However nothing is
too simple I got the following message:
The merge process could not initialize the subscription.
{?=call sp_MSaddanonymousreplica (?,?,?,?,?,?)}
Invalid subscription type is specified. A subscription to publication 'XXX'
already exists in the database with a different subscription
I tried to drop the subscription but said it doesn't exist
sp_droppullsubscription
@.publisher='BUSHWACKER\TEST',@.publisher_db='XXX',
@.publication='XXX'
Server: Msg 14135, Level 11, State 1, Procedure sp_droppullsubscription,
Line 143
There is no subscription on Publisher 'BUSHWACKER\TEST', publisher database
'XXX', publication 'XXX'.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uH#hwylaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> back up the publication database, copy the backup file to the subscriber
and
> restore it there. Then do a nosync subscribption.
> A small snapshot will be generated and distributed to your subscription
with[vbcol=seagreen]
> procs, triggers, and metadata merge needs to work.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Sam" <sam@.info.com> wrote in message
> news:10faqndd1576a3d@.corp.supernews.com...
> without
> is
> (merge
is[vbcol=seagreen]
are[vbcol=seagreen]
2gb[vbcol=seagreen]
"copy[vbcol=seagreen]
be[vbcol=seagreen]
> a
servers.
>
>

copy subscription

I have to insert a lot of subscription, that look very similiar.

How can I copy one subscription to another?

Or is it possible to use a subscription as a template?

Thanks

Just curious, why do you have so many subscriptions?