• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

MS SQL Mirroring - connection breaks and will not reconnect

I have two SQL Server 2005 servers connected via a VPN configured for database mirroring. Last night, the backup server last power and restarted. When it came back up, it said that it was disconnected from its Partner. I tried restarting the SQL service on the backup server to no avail. I know that I can copy the database over and restart mirroring from scratch, but shouldn't the two servers automatically resynchronize? It would be an enormous problem if I had to restart mirroring every time that there was a VPN interruption or a power problem.
0
vls-derek
Asked:
vls-derek
  • 3
1 Solution
 
vls-derekAuthor Commented:
I just restarted the service on the backup server one more time and mirroring restarted, but shouldn't this happen automatically anyway?

Also, is there a way for me to be notified if mirroring fails so I can take action on this immediately?
0
 
vls-derekAuthor Commented:
And it just said disconnected again seconds after restarting.
0
 
vls-derekAuthor Commented:
Fixed login service account issues.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now