DBANewbie (7/9/2013)
I think the error is related to the fact that a task is taking place to create .ndf files on the primary database but when this same task tries to execute on the mirror, the directory it is trying to use is not available so the task fails and the mirroring session is suspended.
Correct.
I can resolve this by dropping and recreating the mirroring session but i was hoping there was a less drastic way around this problem.
I suspect that's what you're going to have to do, unless you can create a drive of the same letter on the mirror server
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability