I have three sql servers that i use for mirroring. One sql server is the principal another the mirror and the third is the witness. I am not sure if the behavior i am experiencing is normal or not but here is what is happening.
sql1 = principal
sql 2 = mirror
sql 3 = witness
The database on sql1 is the backend for our website and when i reboot sql 2 the website is unavailable until both sql1 and sql2 are available. It seems as if something is wrong shouldn't i be able to reboot sql2 (the mirror) and still be able to access the database on sql1 = 1 principal?
Is this normal behavior or do i have something wrong.