November 13, 2013 at 7:45 am
Hello everyone. I have a maintenance plan on my 2008 R2 server that takes a full backup of all the system databases daily. However, the job is failing with the following error:
BackupIoRequest::ReportIoError: write failure on backup device 'D:\DATA_BACKUP\msdb_backup_2013_11_12.bak'. Operating system error 1117(The request could not be performed because of an I/O device error.).
I can see that it is failing to do a backup of the msdb database. The master and model dbs were backed up properly but it is failing on msdb.
However, if I run the same job on Local Disk 'C', it works perfectly without any errors. Disk 'D' is also a local disk.
I did a CHECKDB on msdb but did not find any errors. It is not the hard disk issue because I had my network administrator replace the hard disk with a brand new one and still the problem persists.
Please help me with this. I truly appreciate your help. Waiting for a solution to this issue...
November 13, 2013 at 8:46 am
Anything interesting in the Server's Event Log ??
Maybe hardware, like a controller card ??
November 13, 2013 at 8:56 am
November 13, 2013 at 9:29 am
The error I listed above was from the event log.
Both local disk C and D are similar hard drives with same configurations.
This is a new file.
November 13, 2013 at 10:17 am
If you do a manual backup does it work without issue to the same folder location?
November 13, 2013 at 1:44 pm
It throws the exact same error even if I try to do a backup manually.
Whats strange is that I am able to backup both master and model dbs to the exact same directory location. I am also able to do the backups of user dbs to a different location on the same drive.
It is just the msdb that fails.
December 13, 2013 at 12:24 am
We're having the exact same problem. backup only fails on msdb. Did you find out anything about this issue?
December 16, 2013 at 12:17 pm
No luck yet. Still waiting for a solution. Please update here, if you find a solution.
December 16, 2013 at 12:23 pm
Is there already an earlier backup of the same name at that location?
December 16, 2013 at 12:44 pm
Virtual or Physical Server? Hope this post will be of help.
December 16, 2013 at 12:45 pm
sreekanth bandarla (12/16/2013)
Virtual or Physical Server? Hope this post will be of help.
To be more specific...
December 16, 2013 at 1:36 pm
It is a physical server. There are some old backups but not with the same name.
December 16, 2013 at 1:42 pm
Did you check the status of database MSDB and are the queries executed successfully in MSDB?
Any clue with errors in SQL Error log?
Check out this, may help.
December 16, 2013 at 1:49 pm
Like I mentioned earlier, I did a CHECKDB on msdb and it did not return any errors.
The SQL server log does not contain any errors. The only errors I notice are from the event viewer and it says operating system error 1117.
December 16, 2013 at 2:17 pm
The drive that MSDB is on are there other databases on their too? i.e. Master, model, etc? I know you said you were able to backup those databases and user databases.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply