Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have several databases mirroring with a witness. All 3 machines are local to our network and have generous nics. Monitoring the mirroring, it does not seem like there is a lot of network traffic.

Yet some of the databases' mirroring is pausing without warning. When I restart them, they pause again almost immediately.

What could be the culprit?


EDIT:

Well, now it looks like they are mirroring again...when I went into mirroring manager and tried restarting them, it succeeded now--whereas yesterday it would automatically pause again.

Anyone know why mirrors would just pause? Wouldn't they just failover?

share|improve this question
1  
What does the mirroring monitor say? (Right click database name, tasks) –  Noam N. Kremen Sep 20 '11 at 18:41
add comment

1 Answer 1

up vote 2 down vote accepted

If you query the sys.database_mirroring catalog view you should find out the status of database mirroring from the mirroring_state field. Try this:

select 
    DB_NAME(database_id),
    mirroring_state
from sys.database_mirroring

When it "pauses", what does the mirroring_state show? Here is a legend:

0 = Suspended

1 = Disconnected from the other partner

2 = Synchronizing

3 = Pending Failover

4 = Synchronized

5 = The partners are not synchronized. Failover is not possible now.

6 = The partners are synchronized. Failover is potentially possible. For information about the requirements for failover see, Synchronous Database Mirroring (High-Safety Mode).

NULL = Database is inaccessible or is not mirrored.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.