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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2007-05-09 : 08:22:26
|
| Hi,I plan to use mirroring for high availability purpose. However, I don't undersatand how to redirct to mirror server when principle server is down. I have read some articles about using ADO .Net and SQL native client. However, I don't understand it. Can anyone teach how to setup it by using ADO .NET and sql natyive client step by step? or can anyone post link that teach how to setup?Thank you very much |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-09 : 11:03:58
|
| You have to put both servers in conenction string. |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2007-05-10 : 01:51:43
|
| Thank you for reply.I know to initial principle server and database in connection string. But Where should I place this string?They said Sql Native Client can be used for client redirect. How can I use Sql Native Client?Also, we use IP as server name and link server. will it occurs errors when principle server fails? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-10 : 10:40:17
|
| I saw sample code in msdn. |
|
|
|
|
|
|
Use ADO.NET/ SQL native client for mirroring