March 7, 2010 at 8:32 am
If we have a sql server instance that contains potentially 50+ dbs each with replication (used to move data for reporting) - what are some potential problems to expect?
Is this even the correct approach?
March 8, 2010 at 9:30 am
It depends.
1. Depends on the activity of the databases
2. Depends where the Distributor is
3. Depends on how many distribution DB you have
There are more.. 🙂
There is no way to give a correct advice without knowing the details.
-Roy
March 8, 2010 at 3:10 pm
d-to (3/7/2010)
If we have a sql server instance that contains potentially 50+ dbs each with replication (used to move data for reporting) - what are some potential problems to expect?Is this even the correct approach?
Replication is right approach if you want replicating data at table level, again it depends on business requirements.
If the load is high you may consider separate distributor.
If you want real time data then transactional replication.
If latency is ok for business, then snapshot replication.
If you want data changes propagate to subscriber at database level then Mirroring.
EnjoY!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply