Solved

Backup fail SQL server 2005

Posted on 2008-10-21
6
1,871 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

 
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

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

Question has a verified solution.

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

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
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…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

710 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