Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-29 : 06:26:03
|
| Dear Experts i need to plan for a disastor recovery so please guide me to setup this big process,i've one server xnssrv007 and another server xnssrv008(in one network). i've configured replication on both these systems and working well. so 007 is publisher,distributor and 008 is subscriber.now it became necessary for me to create replication for xnssrv009 also(which is in same network). from 009, i need again to create replication to DR001 which is at 600 miles distance and with 2 MBPS connection.i need the upto date data, so that i want to configure transactional replication.(actually there is no need of 009, but introduced in between because the server should not be in internet)1)is this possible?2)having two subscribers will affect the performance of 007?(the second subscriber at 600 miles distance)3)what will be the latency approximatly for this distance?please guide me in this regardArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-29 : 18:26:42
|
| Anybody need to use DROO server? Can you do Log shipping instead to DR server? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-29 : 23:31:21
|
| 1. possible.2. shouldn't affect 007 much, but may have longer latency to DR001.3. depends on transaction rate and amount of data be replicated, you need test it. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-30 : 01:29:46
|
| Thank you Very much rmiao for your courageous answer for me, and sodeep....actually the main reason behind this is data security and readily avialable delhi data at mumbai and mumbai data at delhi. so that the applications will connect to that(main reason because of this thought is because of recent blasts in india)sodeep thank you very much for the response, and is it better to go for logshipping instead of replication??? may i know how can i get advantage with this instead of replication? particularly in this scenarioArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-30 : 01:36:01
|
quote:
Originally posted by sodeep
Anybody need to use DROO server? Can you do Log shipping instead to DR server?
no sodeep noo ne use this DR001. this setup will be same at delhi and mumbai. so that, from 007 to 009 replication and from there DR001. that is the secured place for data.same setup will be there at both the places. so at both the places,xns007 to xns009 to DR001(in mumbai office)xns007 to xns009 to DR002(in delhi office)DR002 server will be in mumbaiDR001 server will be in delhii think i've explained better now.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 23:25:15
|
| >> is it better to go for logshipping instead of replication??? Depends on if you need real time db sync or not. |
|
|
|
|
|
|
|
|
disaster recovery plan