467,887 Members | 1,615 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,887 developers. It's quick & easy.

Torn Page

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
  • viewed: 2226
Share:
1 Reply
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.

Similar topics

6 posts views Thread by Chandika | last post: by
1 post views Thread by Prashant Thakwani | last post: by
3 posts views Thread by bbbad_999 | last post: by
1 post views Thread by graham.keellings | last post: by
2 posts views Thread by John Lau | last post: by
1 post views Thread by David Greenberg | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.