| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-08-15 : 22:15:38
|
| Yitzchak writes "How can I set up a Backup or Mirror Remote site of my production SQL Servers?Currently I am working with SQL2000 Clusters both Active/Active and Active/Passive on Windows 2000 Clusters.I need to create a remote site, via WAN.How do I do this" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 00:20:21
|
| You can implement Log Shipping or you can implement clustering between the two sites like we are planning to do shortly. Clustering over a WAN though is very expensive, so if it's not in the budget, implement log shipping either using Enterprise Edition or via your own custom scripts.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 00:42:00
|
I still don't see the cost benefit of trying to do clustering over the WAN. :) With SQL Server it doesn't really give you drive redundancy unless you also do a hardware solution like EMC and some other people provide. How are you guys planning on setting it up Tara? I'd be interested in seeing the proposed architecture and what you are really gaining out of it for the cost. We're going to be setting up a hot site here. I want them to use the log shipping scenario to start out with because of how the applications and databases are currently designed (or not designed). Make a good blog, don't you think???  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 00:49:08
|
| Yes we are implementing a hardware solution to mirror the data at the remote site. The two sites are located over 300 miles away from each other. We are having to beef up our pipe between the two sites as well. Cost benefit doesn't matter in this case as it has to do with a new requirement.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 00:59:10
|
| It is active passive mirroring though, right? We would have the first two sites in Kansas City and Ohio somewhere. The mirroring solutions are EXPENSIVE. We already have the bandwidth though. Dual burstable big, big ATM from two major providers. It's crazy.....fun though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 11:54:38
|
| Yes active/passive between the two sites. We also would be clustering at the primary site which would be active/active.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 13:28:36
|
| That makes sense. What's your bandwidth and lag time?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 13:43:41
|
| Dunno. I'm out of the loop on that stuff, I just know that it's huge and that we need it even bigger to support this.Tara |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-08-27 : 01:20:08
|
| be careful with this remote hardware mirroring. It is very tricky.At my last job we were in the process of implementing this type of redundancy using EMC hardware. The product they have is called SRDF, and it was very expensive. At the time EMC did not support an async method of data transport, which meant that our pipe needed to be enormous. Latency is also a potential issue if you have a synchronous approach.Hitachi supports an async method, not sure what Compaq supports on the EVA, IBM supports Async with the ESS (shark). I think EMC has recently licensed this technology (or maybe come up with their own) and have implemented it on their larger boxes. I think the symmetrix 85xx and 88xx support it now and do does the DMX.Anyway, another solution is to use Veritas. THey have an add-on to their LVM product that supports this type of remote mirroring. I have no experience with it other than being told about during a recent dog and pony show with them.-ec |
|
|
|
|
Mirror/Backup Remote Site