March 7, 2012 at 9:07 pm
Hi Expert,
I have plan to do replication within 2 servers. My network bandwidth LAN is 1.0Mbps.
Based on my network bandwidth, this replication is recommended or not.?
Please help me..!
TQ
MZAY
March 7, 2012 at 10:45 pm
Bandwidth is only one of the considerations for choosing the repication topology. The frequency of changes in the publisher and the data staleness will also matter.
e.g if you have a huge db and need changes in real time then its better to try pushing via a seperate distributor using trasnsactional model
If the data doesnt change much and you dont need realtime you could try snapshot model in daily intervals
In you current state , i think need for realtime data will determine the which model to use. 1 MB is not much but Ithink transactional replication is what you shud consider
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply