March 18, 2009 at 7:14 pm
Hello all,
I am getting follwoing error while taking backup on n\w as follows:
Backup device failed - Operating system error; Desc: BackupDiskFile::OpenMedia: Backup device '\\BY2STGOCSQL02\Z$\MSSQL.1\MSSQL\Log\FinalOctaneXmlDB\FinalOctaneXmlDB_backup_200903170800.trn' failed to open
I want to understand why the os tries to open the file when its job is to take backup and save the file only.
-MJ
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
March 18, 2009 at 7:19 pm
MichaelJasson (3/18/2009)
Hello all,I am getting follwoing error while taking backup on n\w as follows:
Backup device failed - Operating system error; Desc: BackupDiskFile::OpenMedia: Backup device '\\BY2STGOCSQL02\Z$\MSSQL.1\MSSQL\Log\FinalOctaneXmlDB\FinalOctaneXmlDB_backup_200903170800.trn' failed to open
I want to understand why the os tries to open the file when its job is to take backup and save the file only.
-MJ
Do you have valid permissions on this file? I mean atleast the job which is performing this backup?
March 18, 2009 at 7:38 pm
Yes. This error occurs temporarily.
I want to understand that when backup would only save the file then why the OS is trying to open the file. Perhaps I am missing something or OS 😉
-MJ
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
March 18, 2009 at 7:55 pm
Is that backup folder shared??
March 18, 2009 at 8:24 pm
Yes this is shared. But my concern is the only behaviour of Operating system. Why should this read the file when we are taking backups. I would not have raised this issue if this would have been recovery process. But this is backup :crying:!!
-mj
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
March 19, 2009 at 2:21 am
I think you may be taking the words "operating system error" a bit too literally. In effect the OS always opens every file - ie low level OS routines will be involved in openeing the file, checking permissions, working out what exact disc sectors it is on etc etc. Thus when sql server tries to do the backup some OS involvement is required to open the file.
Mike John
March 19, 2009 at 3:40 am
Based on my experience, this error is related to OS and Network issue. It has nothing to do with SQL Server.
If the OS is not able to determine the permission level for the file to edit/create, it will raise error. This may be due to some packet lots over network or low bandwidth at given time, high utilization of resouces.
Most of the time, the error goes by itself.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply