July 9, 2013 at 4:17 am
Hi,
I am mirroring databases between 2 servers which have different drive configurations, so the data drive on the principal is D but on the mirror the data drive is F (and there is no D drive on the mirror).
The mirroring works fine but every week or so the session is suspended and i get the following errors:
"CREATE FILE encountered operating system error 3(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'F:\......'"
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.
I can resolve this by dropping and recreating the mirroring session but i was hoping there was a less drastic way around this problem.
Obviously the lesson learnt from this scenario is to use identical drive mappings when setting up a mirror server in future but that isn't really an option here.
Any help would be appreciated.
Thanks in advance.
July 9, 2013 at 4:36 am
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
July 9, 2013 at 4:46 am
I feared this may be the case, thanks for taking the time to respond.
August 27, 2014 at 6:04 am
You get "Access is denied.". So, it seems like the service account for SQL Server doesn't have permissions on where you try to produce the backup file.
August 27, 2014 at 8:17 am
DBANewbie (7/9/2013)
I can resolve this by dropping and recreating the mirroring session
And that's exactly what Books Online tells you to do 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2014 at 8:18 am
enriquemallon (8/27/2014)
You get "Access is denied.". So, it seems like the service account for SQL Server doesn't have permissions on where you try to produce the backup file.
The error is due to the miror session trying to create a file on a drive on the mirror which doesn't exist 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply