Replication issues with multiple databases

I am planning to use replication from 400 databases to the master database on
a periodic basis. Do you see any issues with that ?
All databases have the same structure
Alu,
this is a bit vague as it stands but certainly this is 'possible'. In
this link they discuss scaling merge to 2000 subscribers:
http://www.microsoft.com/technet/pro...mergperf.mspx.
For your setup, the type of replication selected will have some
implications. There are also implications with the type of topology
selected, hardware available, bandwidth, data volume etc so really you just
have to implement it, monitor using Perfmon and then see how it goes. As an
aid to avoid contention (data and disk) you might need to consider
staggering synchronization.
Regards,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Replication issue

Hi everybody,
I have a 2000 to 2005 snapshot replication that has been working
optimally on a nightly basis for months now. I continue to add
articles and new fields to the publisher and these are brought into
the SQL 2005 64 bit box via a pull subscription. We recently modified
a field from 5 to 6 chars and with everthing I read, I have to drop
the subscription to alter the field on the publisher. I have dropped
the field out of the published fields on that table to no avail. Is
there any way around this? If I make a mistake, can I just restore the
distribution db back to get my replication the way it was?
Any ideas? I need to get this done pretty soon...
Thanks,
KristinaPlease take a look at this article:
http://www.replicationanswers.com/AddColumn.asp
Cheers,
Paul Ibison|||On Jun 23, 1:36 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Please take a look at this article:http://www.replicationanswers.com/AddColumn.asp
> Cheers,
> Paul Ibison
perfect thanks! I had forgotten this, I need to drop and re-add...

Replication issue

Hi everybody,
I have a 2000 to 2005 snapshot replication that has been working
optimally on a nightly basis for months now. I continue to add
articles and new fields to the publisher and these are brought into
the SQL 2005 64 bit box via a pull subscription. We recently modified
a field from 5 to 6 chars and with everthing I read, I have to drop
the subscription to alter the field on the publisher. I have dropped
the field out of the published fields on that table to no avail. Is
there any way around this? If I make a mistake, can I just restore the
distribution db back to get my replication the way it was?
Any ideas? I need to get this done pretty soon...
Thanks,
Kristina
On Jun 23, 1:36 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Please take a look at this article:http://www.replicationanswers.com/AddColumn.asp
> Cheers,
> Paul Ibison
perfect thanks! I had forgotten this, I need to drop and re-add...

Replication issue

Hi everybody,
I have a 2000 to 2005 snapshot replication that has been working
optimally on a nightly basis for months now. I continue to add
articles and new fields to the publisher and these are brought into
the SQL 2005 64 bit box via a pull subscription. We recently modified
a field from 5 to 6 chars and with everthing I read, I have to drop
the subscription to alter the field on the publisher. I have dropped
the field out of the published fields on that table to no avail. Is
there any way around this? If I make a mistake, can I just restore the
distribution db back to get my replication the way it was?
Any ideas? I need to get this done pretty soon...
Thanks,
KristinaPlease take a look at this article:
http://www.replicationanswers.com/AddColumn.asp
Cheers,
Paul Ibison|||On Jun 23, 1:36 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Please take a look at this article:http://www.replicationanswers.com/AddColumn.a
sp
> Cheers,
> Paul Ibison
perfect thanks! I had forgotten this, I need to drop and re-add...