SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 msdb backup fails
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ravi8teja
Starting Member

3 Posts

Posted - 11/13/2013 :  09:50:06  Show Profile  Reply with Quote
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

United Kingdom
22403 Posts

Posted - 11/19/2013 :  09:40:01  Show Profile  Reply with Quote
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 - 11/21/2013 :  06:53:01  Show Profile  Reply with Quote
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 - 12/16/2013 :  14:22:57  Show Profile  Reply with Quote
Guys, still looking for a solution to this. Somebody please help!!!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36582 Posts

Posted - 12/16/2013 :  15:29:54  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
788 Posts

Posted - 12/24/2013 :  13:22:41  Show Profile  Reply with Quote
Could this be related to your issue?

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

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000