Backup fail SQL server 2005

Posted on 2008-10-21
Medium Priority
Last Modified: 2012-05-05
I keep running into error messages while trying to run a backup using SQL server 2005. Running the backup task is working alright but when I try to run a backup of the transaction logs I keep running into errors.

Here's the error messages.

Error: 18210, Severity: 16, State: 1.
2008-10-21 13:42:11.68 spid51      BackupMedium::ReportIoError: write failure on backup device 'F:\Backup\%mybackupfile%.trn'. Operating system error 1117(The request could not be performed because of an I/O device error.).
2008-10-21 13:42:11.68 Backup      Error: 3041, Severity: 16, State: 1.
2008-10-21 13:42:11.68 Backup      BACKUP failed to complete the command BACKUP LOG %mybackuplog%. Check the backup application log for detailed messages.
Question by:bkort1
  • 3
  • 2
LVL 32

Expert Comment

by:Daniel Wilson
ID: 22770642
Is the f: disk full?  Or close enough to full that the free space < the size of the LDF file?

Author Comment

ID: 22777192
No the f: drive has plenty of room, we tried other locations as well with no success.  Any suggestions?
LVL 32

Accepted Solution

Daniel Wilson earned 1500 total points
ID: 22779931
In your System Event Log, are you logging any other disk-related problems?
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

LVL 41

Expert Comment

ID: 22813011
The fact that the error message contains "%mybackupfie%" is a bit suspicious to me... it looks like it's not evaluating the environmental variable.
... or did  you just do that for posting it here?

Author Comment

ID: 22823927
Actually I put "%mybackupfie%" just for posting here.

I am pretty sure that the problem has been solved, since the last two backups have been successful.
One of the databases was set to "simple" in the recovery model, I changed it to "full", and made sure they were all set at the right compatibility level.  Its working alright for now.
LVL 32

Expert Comment

by:Daniel Wilson
ID: 22824200
>>I am pretty sure that the problem has been solved

Cool.  Would you share the solution so we all learn?

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question