2

I am trying to take backup of one DB Which is showing Continuosly I/O Error 21 (The device is not ready) deteceted during read at offset 0x000000000000000040 in file e:\test.ndf Error 823. The Step Failed.

The backup was running smoothly for last 2 years.

Database Configuration is Test.mdf--->d:\ Test.ldf----> D: Test.Ndf----> E:\ USB Drive

Database is running smoothly.

4 Answers4

2

This is not a backup error: it's a database error in one of your database files. Backup can't read it and eventually you'll get it in normal operation.

You mention error 823, It's nasty: a hard IO error

To verify, run DBCC CHECK DB and see Paul Randall's site for "823". he wrote DBCC CHECK DB

...it says that an I/O operation failed at the OS level and the I/O subsystem is causing corruption...

Could be a good time to check your backups...

gbn
  • 6,099
1

Things to check are:

  • Is there a problem with the USB drive?
  • Is the USB drive connected?
  • Has the drive name of the USB drive changed?
  • Is the USB drive full?
Shiraz Bhaiji
  • 2,279
0

Are you confident your backup is not corrupt? Can you try using a different backup to confirm it is not your file? Also try running DBCC CHECKDB and check for logical and physical database issues.

northpole
  • 191
0

Sounds like your USB drive is having issues. Can you access the drive? You could try relocating the file to another drive. If you can't copy the file over with SQL Server down then it might be a Physical storage issue.

Russ960
  • 243