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 |
|
MuadDBA
628 Posts |
Posted - 2004-11-04 : 14:38:16
|
| I have SQL Server on a cluster, conencted to a SAN at my HQ building. They want to mirror it the Chicago HQ.The kicker is, they want to use a single server in Chicago, not a cluster. I beleive they are looking at SAN replication of some sort which will leave the files open for modification, etc. However, I don't know how SQL Server would react to that sort of thing. Would it care? Has anyone else done this?I know, it sounds a little foolish, but is this possible? |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-04 : 14:48:15
|
| Maybe log shipping would be the way to handle this?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-11-04 : 15:10:26
|
| They don't want to do that....they want to do a block-level copy from one SAN to another. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-04 : 15:19:30
|
| I'm not sure how SQL Server would react to such a thing. What about stuff that has not been written to disk yet?? Methinks you'd need to talk to your SAN vendor and see how their SAN replication deals with SQL server.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
|
|
|