Complex Mirroring project , need suggestions !
We have an interesting project to work on. A client has issued a clear directive to us. He wants his server up @ all costs. He is willing to have his server mirrored at three DCs in different time zones. He just wants his server up serving data even if any of the other servers are yanked off.
The OS has to be Windows and SQL too is necessary. How can all of this be mirrored across servers in different DCs and most importantly how can each of them go alive if one of them goes down. Please let me know what kind of options are available if we intend to pull this off
Cheers,
