By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,492 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,492 IT Pros & Developers. It's quick & easy.

Torn Page

P: n/a
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

Nov 1 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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)
Nov 2 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.