May 31, 2002 at 5:34 pm
Any Idea what should I do?
Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x00000167898000
in file 'C:\Data\MyDatabase\File_2.ndf'.
I have recommended:
[1] Check the accessibility and condition of C drive.
[2] Run hardware diagnostics and correct problems, if any.
Any thing else I should see..
Thanks,
NeoNash
May 31, 2002 at 8:12 pm
I have never seen the "bad page ID" statement but error 823 I have with insufficient resources, take a look here may over some here http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=823&Queryc=823&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=25
Also might try using DBCC CHECKDB with one of the repair options if the above does not help (Make a backup of the files beforehand just in case under any circumstance).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply