Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 msdb backup fails

Author  Topic 

ravi8teja
Starting Member

3 Posts

Posted - 2013-11-13 : 09:50:06
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...

Kristen
Test

22859 Posts

Posted - 2013-11-19 : 09:40:01
Disk full on Drive D?

Unless you have a Housekeeping job running that deletes history of old backups etc. MSDB will grow forever. If the server has been running a long time and/or has a lot of databases the size of the history will already be "big"
Go to Top of Page

ravi8teja
Starting Member

3 Posts

Posted - 2013-11-21 : 06:53:01
quote:
Originally posted by Kristen

Disk full on Drive D?

Unless you have a Housekeeping job running that deletes history of old backups etc. MSDB will grow forever. If the server has been running a long time and/or has a lot of databases the size of the history will already be "big"




No, lot of free space available on the hard disk. And like I said it is not the hard disk issue because I had my network administrator replace the hard disk with a brand new one and the issue still exists.

Also, the issue exists even if I try to do a backup of msdb manually to that location on the drive.

I am stuck here and I need some help with this.
Go to Top of Page

ravi8teja
Starting Member

3 Posts

Posted - 2013-12-16 : 14:22:57
Guys, still looking for a solution to this. Somebody please help!!!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-12-16 : 15:29:54
I would open a case with Microsoft as you've covered what I would try.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2013-12-24 : 13:22:41
Could this be related to your issue?

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

Go to Top of Page
   

- Advertisement -