Thanks Perry,

I DID need to restart SQL as you suggested.

Just a restart was sufficient in this case. I didn't need to touch the data files (which was plan...

Hi Perry,

Thanks for your reply(ies).

I'm not sure why this mirror failed to switch roles & back. But I've learned a few things along the way:

1) as soon as...

Mmmm, I'm 98.86% the force allow option is the correct next step ...

Failing that a SQL restart.

Any 2nd opinons?

Thank you.

No sorry perhaps I've not been clear. 1 principal. 1 mirror. 70 DBS. 68 switched roles correctly when principal SQL instance was switched off. When original SQL principal instance restarted...

Thanks. I don't fully understand what restarting the end points does. Could it affect any of my other correctly mirroring live DBS?

Sorry for the delay ... and thanks for the replies. No, they were on different servers at different locations. I'm at a loss to explain it. There...

Everything I'm reading points to connection type issues / endpoints etc. but I can't explain this at the database level?

Great, thanks all! Appreciate the reply.

Thank you both, but aren't you both saying different things?

M&W unavailable. Does the P stay online?

Ok, thank's for your time!

Thanks for taking the time to reply.

I'd prefer a retrospective solution rather than waiting for a re-occurence.

I was wondering if there's a DMV somewhere that records transaction...

Dumb answer: Machine accounts. I was using the wrong terminology to google with.

Thanks for the reply.

As usual around here, it's not been thought through at all. :).

Cheers.

Thanks, grateful for confirmation.

He wants to do it because my client is a busy fool throwing out poorly thought out "solutions" to requirements he hasn't properly analyzed or...

Thanks, it seems like a complicated solution to what I thought would be simpler.

I'll have to make it dynamic because the 'characteristic' values may change, but, presuming there's no...