SQL server 2008 r2 mirroring

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.
LVL 3
IKtechAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Eugene ZConnect With a Mentor Commented:
it is not, did you check sql error log; mirror alerts

is sql1 = principal online during sql 2 = mirror reboot?
can you check your website application config\connection string settings?
0
 
IKtechAuthor Commented:
it is probably worth mentioning that the mirroing is using high safety with automatic failover.
0
 
Eugene ZCommented:
<Is this normal behavior>
It is not
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
IKtechAuthor Commented:
SQL1 is online and so is the witness.  When i reboot the mirror (sql2) the database on the principal states (principal disconnected in recovery).  And as soon as the mirror comes back up things return to "normal".  I just had an issue where i could not get sql server service to start on the witness so i reinstalled SQL which got me back to where i could start sql server service again.  I also removed mirroring and configured it again after reinstalling.
0
 
IKtechAuthor Commented:
I just changed the log on credentials for the "sql server agent" service and tested.  Seems good to go.  you get the points for trying help.  Thanks!
0
 
IKtechAuthor Commented:
Fixed it myself but i thank you anyway
0
All Courses

From novice to tech pro — start learning today.