Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

msdb backup fails. Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 7:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:04 AM
Points: 7, Visits: 17
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...

Post #1513897
Posted Wednesday, November 13, 2013 8:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:19 AM
Points: 2,826, Visits: 8,462
Anything interesting in the Server's Event Log ??

Maybe hardware, like a controller card ??



Post #1513931
Posted Wednesday, November 13, 2013 8:56 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 9:14 PM
Points: 564, Visits: 851
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
Post #1513937
Posted Wednesday, November 13, 2013 9:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:04 AM
Points: 7, Visits: 17
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.
Post #1513948
Posted Wednesday, November 13, 2013 10:17 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:31 AM
Points: 999, Visits: 13,473
If you do a manual backup does it work without issue to the same folder location?
Post #1513977
Posted Wednesday, November 13, 2013 1:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:04 AM
Points: 7, Visits: 17
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.
Post #1514052
Posted Friday, December 13, 2013 12:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 6:43 PM
Points: 2, Visits: 72
We're having the exact same problem. backup only fails on msdb. Did you find out anything about this issue?
Post #1522590
Posted Monday, December 16, 2013 12:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:04 AM
Points: 7, Visits: 17
No luck yet. Still waiting for a solution. Please update here, if you find a solution.
Post #1523395
Posted Monday, December 16, 2013 12:23 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:58 PM
Points: 529, Visits: 1,561
Is there already an earlier backup of the same name at that location?
Post #1523397
Posted Monday, December 16, 2013 12:44 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 260, Visits: 1,030
Virtual or Physical Server? Hope this post will be of help.
http://erinstellato.com/2011/04/some-errors-not-they-seem/
Post #1523405
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse