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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-25 : 08:57:45
|
| Nelson writes "Would anybody know, if possible, setup SQL 2005 in an active active solution across two geographic datacenters with web servers as the user interface? Both database servers have to accept read writes to the db and the db must sync across both db server.Thank You" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-25 : 11:51:43
|
| I hope you have a lot of dough.google "geographically dispersed clusters"-ec |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-05-25 : 16:47:52
|
| I've gone down that path with SQL Server 2000. Yes, you need a LOT of dough to make that happen. I'd say at a minimum around $250k, but realistically closer to $500k+ depending on "how fast" each system is.You also need to make sure that the two locations are not too far away. The PING time needs to be really low (like below 50ms) and you need to have a fat pipe between the two systems.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
|
|
|
Active Active SQL 2005 Server across two datacenters.