msdb backup fails.

  • 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...

  • Anything interesting in the Server's Event Log ??

    Maybe hardware, like a controller card ??

  • It doesn't sound like a SS issue. Sounds like an OS/HW issue. Is this a new file or are you appending/overwriting an existing file?



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • 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.

  • If you do a manual backup does it work without issue to the same folder location?

  • 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.

  • We're having the exact same problem. backup only fails on msdb. Did you find out anything about this issue?

  • No luck yet. Still waiting for a solution. Please update here, if you find a solution.

  • Is there already an earlier backup of the same name at that location?

  • Virtual or Physical Server? Hope this post will be of help.

    http://erinstellato.com/2011/04/some-errors-not-they-seem/

  • sreekanth bandarla (12/16/2013)


    Virtual or Physical Server? Hope this post will be of help.

    http://erinstellato.com/2011/04/some-errors-not-they-seem/

    To be more specific...

    http://support.microsoft.com/kb/2519834

  • It is a physical server. There are some old backups but not with the same name.

  • 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.

    http://support.microsoft.com/kb/2519834

  • 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.

  • 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.



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply