Thanks Sean, appreciate the response. Understand what you're saying about dev help. Looking mostly for a starting point I guess. I'm principally a DBA but happy to...

Ok, thanks all. Appreciate the feedback.

Much obliged!

Thanks Gail.

This is only a hypothetical but am I right in saying that it would not be possible to manually fail back until the comms issue was resolved?

ie....

Thanks for the response to another of my posts! I appreciate the confirmation of how it should work and the 2nd opinion.

The design is completely ill conceived but...

No, the file server has just been created as a separate cluster resource.

If I had a test system, I could try a few things instead of bothering forum...

Yes so ...

BULK INSERT table

FROM '\\x\y\z\data.dat' WITH (FORMATFILE='C:\t_floatformat-c-xml.xml');

GO

Which works when the file server is on the same node as the instance, and fails when I fail the file server over...

ok, thanks for replying.

How does it work during a failover?

2008 R2 btw, I guess that's implied from the forum but just to be clear. Thank you!

Thanks all for taking the time to reply.

spaghettidba spot on. I'd been using the profiler to trace errors (which yielded nothing) but hadn't realised there was a separate failed...

what if the question was just ... i have some spids from a 3rd party app that seem 'stalled', forever, until I kill them.

is there anything i can do to...

Thanks Gail, I find it confusing the way you can seemingly give permissions at the database level as well for a sysadmin.

Appreciate the swift response.

Thanks for the reply, what happens if I "pause mirroring" then take the box with the witness / mirror down?

No problem, if no one knows / can be bothered to...

Interesting. Thanks Gazareth. PARTNER_TIMEOUT. I hadn't clocked that there was such a value.

Re: instance / database level, I guess thinking it through, it doesn't really...