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 |
|
pea
Starting Member
1 Post |
 Posted - 2011-09-19 : 15:48:17
|
| Hi,We are running database mirroring synchronous mode (with witness) over three sites.The principal and Mirror databases are running on Windows Server 2008 R2 64bit, and SQL Server 2008 R2 Enterprise 64bit.The Witness is running on Windows server 2003, SQL Server Express edition.I needed to perform some maintenance on the network, so I paused mirroring on the principal before working on the firewall.I then took down the firewall at the principal site, expecting the principal database to carry on as normal (as the mirror was paused), however the principal database became unavailable!I understand that the database would go offline if I didn't pause mirroring (as it would lose connection to the mirror and witness), however I didn't expect it to go offline when it was paused!Am I doing something wrong?Thanks for your help |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-09-20 : 02:40:51
|
| You should probably wait for some more experienced dba's to answer here but did you see any error messages in the logs? What do you mean when you say that the principal "became unavailable"? As far as I know nothing in regards to mirroring should make the principal become unavailable (except for a failover naturally).- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
|
|
|
Mirroring problem