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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment