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 |
|
stumbling
Posting Yak Master
104 Posts |
 Posted - 2009-10-19 : 03:47:21
|
| Hi AllWe are contemplating DB mirroring using High Availability and a witness server. There are so many questions but the main one i need to know is how does the client app that uses an ODBC connections and points to say serverabc know automatically to jump to serverdef?I know how it works in our cluster environment and wonder does it work the same using a virtual IP so to speak?Any news would be great.Cheers |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2009-10-19 : 16:35:00
|
| Thanks for that i gather if you dont use the Native driver then you are forced to manually alter all client apps. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2009-10-19 : 18:09:35
|
| Thanks for that DNS Alias mmm.One other question is I have looked all over the place for limitations of mirroring but found not much? We were told that it only supports 10 databases on any one instance of SQL have you seen anything about this? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2009-10-19 : 19:10:22
|
| Thanks for that it info gives me somewhere to mabe start looking at.Cheers |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Mirroring