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 |
|
dreams3577
Starting Member
2 Posts |
 Posted - 2007-11-19 : 19:51:23
|
| Hi AllHave a new app with a SQL 2005 single database.The app is web based (IIS) for most of the users (80% of users) and fat client for the rest of the users (20% of users).. Total user count is 7000.App needs to be high availability across two sites (approximatly 30 miles apart with a 1000mb connection between sites).Budget is not a issue, all new hardware needs to be purchased. and so my question is what is the best solution that will allow users to connect and use the app quickly from each site?many thankssteve |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-19 : 23:47:18
|
| What kind of link between sites? May replicate db with peer-to-peer replication. |
 |
|
|
dreams3577
Starting Member
2 Posts |
Posted - 2007-11-20 : 03:36:08
|
quote:
Originally posted by rmiao
What kind of link between sites? May replicate db with peer-to-peer replication.
Hi rmiaoA Lez 1000 fibre link.. with a network latency of 1msthankssteve |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 16:53:45
|
| Then you can try replication. |
|
|
|
|
|
|
SQL 2005 based app