did DBCC CHECKDB

views:

answers:

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.

+2 A:

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.

Wyatt Barnett 2009-09-17 13:53:29

the server was restarted and it worked

vas 2009-09-17 19:56:24

That's good, but are you sure something important, like the hard drive your data lives on, isn't failing?

Wyatt Barnett 2009-09-17 20:59:54

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.

gbn 2009-09-17 14:09:48

ansaurus

tags:

views:

answers:

did DBCC CHECKDB

related questions