did DBCC CHECKDB

Question

Help getting crushed by this

i did DBCC CHECKDB and one of the DB gave Msg 823, Level 24, State 2, Line 2 I/O error 21(The device is not ready.) detected during read at offset 0x0000000001c000 in file 'E:\MSSQL2000\Data\FTSWE_Data.MDF'.

I was working on a remote server, from my, local host accessing a remote DB.

Also i was on VPN.

score 2 · Answer 1 · answered Sep 17 '09 at 13:53

2

Probably belongs on serverfault. Anyhow, I would contact whomsoever is hosting the box, it seems like there is a nasty disk error brewing. I hope you have backups, etc.

answered Sep 17 '09 at 13:53

Wyatt Barnett

15,573
3
34
53

That's good, but are you sure something important, like the hard drive your data lives on, isn't failing? – Wyatt Barnett Sep 17 '09 at 20:59

score 0 · Answer 2 · answered Sep 17 '09 at 14:09

Error 823 is nasty. It's a hard IO error

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...

I'd double check your backups now and call them to make sure they know something is wrong.

did DBCC CHECKDB

2 Answers2