Jump to content
Welcome to our new Citrix community!
  • 0

SQL Mirroring - Constant Restoring


Joshua Lindemann

Question

I've setup the SQL database mirroring in the past, but for some reason we had to break the connection.  Going back and trying to get HA in place again I'm re-setting everything back up again.  But in doing so I'm finding that the databases I restore to my mirror server are constantly in "restoring..." mode.  And they never come out of it.

 

I went through all my notes properly, and I've looked online and I've done it correctly.  I've tried it numerous times, but "restoring..." just won't go away.

Databases are backed up FULL

When restored, chose the option NORECOVERY

 

When building the mirror it shows that everything is synchronized, but it's still showing the restoring... indicator.  (see attached image) It's been like this for the past 24hours.

 

I'm just afraid that if it were to fail over to the mirror, it won't be able to properly access the database and HA won't be there. (since you typically can't access the database when it's in that mode)

 

Capture.PNG

Link to comment

2 answers to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...