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 |
|
lasko
Starting Member
2 Posts |
 Posted - 2010-12-23 : 18:25:19
|
| hi all hope you all welli have application that connect to sql server 2008 what i want is make standby server (this standby server should be mirror of primary one) when connection failed to primary server automatically switched to standby server without modifying my application so if there is way please tell me in detail or if even there is third party note that i need set connection my application to primary server only thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
lasko
Starting Member
2 Posts |
Posted - 2010-12-24 : 17:26:05
|
quote:
Originally posted by tkizer
Look into synchronous mirroring with a witness and the SQL Native client.
thank you for your replaying but can you provide me with more details best regard |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-25 : 15:44:42
|
| Books have been written on mirroring. Go do some reading up on it, there's a lot of information available. Key terms are 'database mirroring' and 'transparent client redirect'--Gail ShawSQL Server MVP |
|
|
|
|
|
|
how to set standby server