DB backups failing (error 1117)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

DB backups failing (error 1117)

Author

Topic

steel
Posting Yak Master

107 Posts

Posted - 2010-03-17 : 02:44:03

Dear Experts,

We are getting error while taking backup of a database on local Drive( Operating system error 1117 (The request can not be performed because of I\O device error)).

Details
SQL server 2000
SP4
windows server 2003+sp2

Thanks in advance

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-03-17 : 03:50:47

What kind of disk is this and how is it formatted? Have you used this disk for backups before? Have you checked the disk for consistency?

- Lumbago
If the facts don't fit the theory, change the facts. Albert Einstein

steel
Posting Yak Master

107 Posts

Posted - 2010-03-17 : 04:58:35

Yeah the disk is used for backups and the consistencies are verified after running chkdsk in safe mode on the server but all in vain.

Kristen
Test

22859 Posts

Posted - 2010-03-17 : 05:18:36

DBCC CHECKDB the database? - maybe the problem is in the DB rather than the medium for the backup file?

steel
Posting Yak Master

107 Posts

Posted - 2010-03-17 : 06:07:01

Hi Thanks for the reply...

I have checked the same and no errors found in the database.

Kristen
Test

22859 Posts

Posted - 2010-03-17 : 07:05:48

Silly question probably, but the disk isn't becoming full is it?

steel
Posting Yak Master

107 Posts

Posted - 2010-03-17 : 16:36:15

No there is lot of free space on the server .....

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-17 : 17:15:35

You need to work with your Windows system administrator on this as this isn't a SQL Server issue. It's a disk problem. Can you contact the vendor of your disks for help?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

steel
Posting Yak Master

107 Posts

Posted - 2010-03-23 : 14:25:19

Dear Experts,

Thanks for the suport ,the issue was with the Hard Disk.

thanks for your support.

Krish85
Starting Member

1 Post

Posted - 2011-01-09 : 15:50:06

Hi
Can you please let me know how did u resolved this issue. cause i'm facing the same issue.

Krish

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-09 : 22:46:41

Krish, check your disks.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

joeller
Starting Member

15 Posts

Posted - 2011-06-03 : 14:25:26

I am getting the same error while trying to do a restore and there is NOTHING wrong with my hard drive. The restore filelistonly from the same file reads just fine. And the restore database command for other backup files in the same folder works just fine.

What else can be the source of this error?

E.R. Joell MCDBA

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-03 : 15:53:50

Restore Filelist only reads the header of the backup. If there's a problem that only manifests further into the file, the filelistonly will succeed and the restore fail. If could be a problem with just a small portion of the drive.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources