Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring Suspended - OS error 3 Reason 15105 Expand / Collapse
Author
Message
Posted Tuesday, July 9, 2013 4:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 5:27 AM
Points: 116, Visits: 651
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.

Post #1471524
Posted Tuesday, July 9, 2013 4:36 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: 2 days ago @ 2:01 PM
Points: 40,390, Visits: 36,823
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1471528
Posted Tuesday, July 9, 2013 4:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 5:27 AM
Points: 116, Visits: 651
I feared this may be the case, thanks for taking the time to respond.
Post #1471532
Posted Wednesday, August 27, 2014 6:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 1:09 AM
Points: 33, Visits: 54
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.
Post #1607788
Posted Wednesday, August 27, 2014 8:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:21 PM
Points: 6,618, Visits: 14,183
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"
Post #1607851
Posted Wednesday, August 27, 2014 8:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:21 PM
Points: 6,618, Visits: 14,183
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"
Post #1607852
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse