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 |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2008-03-31 : 09:13:15
|
| I'm currently looking at setting up database mirroring using SQL 2005 had a thought regarding automatic failover using a witness. We have an application that is provided by a third party, and it connects to the DB by referencing an ODBC connection set up on each individual machine.My question is how will the application be able to connect to the mirrored DB in case of a failover? Would I set the ODBC connection to point to the witness? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 09:33:38
|
| Many application are already cached in memory (drivers like SQL native client) but microsoft has suggested to use connection strings to be sure application fails over automatically.Connection strings include :failover partnerCheck: Application failover in database mirroring in google. |
 |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2008-03-31 : 09:43:44
|
| Thanks for the reply. By using the SQL Native Driver I can specify a mirror DB. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 09:46:29
|
| Did you check "Application failover in database mirroring "? It will give you details. |
|
|
|
|
|
|
SQL Mirroring question