Torn Page

[jennifer1970]

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?

Thanks,
Jennifer

[Trevor Best]

je**********@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)