Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Backup fail SQL server 2005

Posted on 2008-10-21
6
Medium Priority
?
1,875 Views
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.
0
Comment
Question by:bkort1
  • 3
  • 2
6 Comments
 
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?
0
 

Author Comment

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

Accepted Solution

by:
Daniel Wilson earned 1500 total points
ID: 22779931
In your System Event Log, are you logging any other disk-related problems?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 41

Expert Comment

by:graye
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?
0
 

Author Comment

by:bkort1
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.
0
 
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?
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

971 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