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 |
|
TiGGi
Starting Member
29 Posts |
 Posted - 2008-05-25 : 11:08:09
|
| Hi there,I am testing the db mirroring, making sure it will auto failover. I've stopped the SQL services on my principal and then I looked at the mirror db is says it's restoring. It stayed like that for 10 min before I enabled the mirroring again. Anyone knows why it's not failing over??????Here's my setup: SQL 2005 Standard, Server 1 Principal, Server 2 Mirror & Witness. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-25 : 11:18:03
|
| It should if you had setup Mirroring correctly? |
 |
|
|
TiGGi
Starting Member
29 Posts |
Posted - 2008-05-25 : 12:07:10
|
| It is, it's in high safety automatic failover mode. DB mirroring monitor say it running good and dBs are synchronized. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-25 : 14:25:08
|
| Witness must be on separate instance from principlal and mirror. |
|
|
|
TiGGi
Starting Member
29 Posts |
Posted - 2008-05-25 : 15:51:13
|
| Thanks, I was under impression that this setup should work for auto failover, I guess I was wrong! |
|
|
|
|
|
|
Automatic Failover