Posted by Trevor Best on 11/02/05 10:22

jennifer1970@hotmail.com wrote:
> Hi all. I'm getting an error mssage which tells me I have a torn page:
>
> ODBC error 823 (HY000) I/O error (torn page) detected during read at
> offset 0x00000080b5c000 in file 'D:\WINSUPPORTDATA\Win Support
> Database_2_Data.NDF'.
>
> I ran DBCC CHECKDB and it returned no errors:
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'WIN Support Database'.
>
> I really don't know what to do at this point. I'm not a database
> administrator, just a programmer, and our DBA is not here. Any
> suggestions?

first off, if you haven't already... BACK UP!!!

Any i/o errors would invite me to run chkdsk, if you do, don't use the
Windows GUI one, run the command line one and make sure you use the /f
parameter so it locks the disk or does it on a restart. If it doesn't
have exclusive access to the disk it may report errors that aren't
actually there.

Back up first (I know I mentioned that b4, but its worth mentioning again)

[Back to original message]