Solved

Backup fail SQL server 2005

Posted on 2008-10-21
6
1,866 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 500 total points
ID: 22779931
In your System Event Log, are you logging any other disk-related problems?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Best Server Board For The Money 19 72
Free HD cloner 11 59
Virtual Disk RAID 0 - OMSA reporting it has bad blocks 6 35
Help Required 2 29
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now