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 |
|
mzollars21
Starting Member
1 Post |
 Posted - 2011-09-27 : 14:33:15
|
| Hello,We are testing out database mirroring. We have serveral databases setup with mirroring and auto failover with a witness server. Everything is working well except for we noticed if one of the databases fails over it seems that all connections for the rest of the databases go to the failover database as well even though those database have not failed over and still reside on the principal. Any ideas as to why this would happen? Is this expected behavior? Here is an example of the the connection strings that we are using.jdbc:sqlserver://server1.example.com:1433;failoverPartner=//server2.example.com:1433;database=databasename1jdbc:sqlserver://server1.example.com:1433;failoverPartner=//server2.example.com:1433;database=databasename2Thanks |
|
|
|
|
|
sql 2008 database mirroring with a witness server