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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2007-09-18 : 22:45:06
|
| our compnay plan to implement data High availability solution. The idea is the db server will connect 2 SAN. those 2 SAN have exect the same database files. so when one SAN failed, db server can use another SAN.So here are some questions1. Can SQL write data into 2 SAN at the same time? If SQL doesn't support this, are there softwares that can replicate data between 2 SAN?3. Are there other good solutions? Thank you in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-18 : 23:15:03
|
| SAN should have this kind of tool itself. But I think you better to have two sql servers, so that you'll have real DR solution. Xosoft has tool to handle sql server DR. |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2007-09-19 : 02:49:26
|
I understand what you say but our company want to save money on hardware.:(So, Is that possible SQL can write data to 2 SAN synchronizly?quote:
Originally posted by rmiao
SAN should have this kind of tool itself. But I think you better to have two sql servers, so that you'll have real DR solution. Xosoft has tool to handle sql server DR.
|
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-19 : 02:59:27
|
| i am not aware of a way to do this just from SQL server. SAN to SAN it would be possible though (EMC has SRDF, not sure what other vendors call their technology). You could accomplish something similar by using database mirroring, which is a SQL 2005 feature. this would require two sql servers though.-ec |
|
|
|
|
|
|
data high availability solution