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

Err. 823 Torn Page Detected

P: n/a
Hi all,

One of my database was suspected, So I try to recover database then it
gives this error

Err. 823 Torn Page Detected

823, ... 24, spid51 i/o error Torn Page (Detected)
during read at offset 0x0000000040e0000 in file .........
How can I recover my SQL Server 2000 Database? Please help

Thanks
Jul 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Thu, 07 Aug 2003 03:51:25 -0700, Chandika wrote:
One of my database was suspected, So I try to recover database then it
gives this error

Err. 823 Torn Page Detected

823, ... 24, spid51 i/o error Torn Page (Detected) during read at
offset 0x0000000040e0000 in file .........
How can I recover my SQL Server 2000 Database? Please help


This is an indication that there was a hardware failure resulting in a
partial I/o completion corrupting the database. You need to restore a
backup and recover it up to the present using the logs.

If you don't have a suitable backup and logs, you can place a call to
Microsoft support and ask them to try to recover as much of the data as
possible for you.

Hal
Jul 20 '05 #2

P: n/a
"Hal Berenson" <ha*****@truemountainconsulting.com> wrote in message news:<pa****************************@truemountainc onsulting.com>...
On Thu, 07 Aug 2003 03:51:25 -0700, Chandika wrote:
One of my database was suspected, So I try to recover database then it
gives this error

Err. 823 Torn Page Detected

823, ... 24, spid51 i/o error Torn Page (Detected) during read at
offset 0x0000000040e0000 in file .........
How can I recover my SQL Server 2000 Database? Please help


This is an indication that there was a hardware failure resulting in a
partial I/o completion corrupting the database. You need to restore a
backup and recover it up to the present using the logs.

If you don't have a suitable backup and logs, you can place a call to
Microsoft support and ask them to try to recover as much of the data as
possible for you.

Hal

Thanks lot Hal
Jul 20 '05 #3

P: n/a
I have downloaded third part software, That tool can recover but data
come up with demo, So I believe we should have method to recover it. If
anybody knows please reply...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #4

P: n/a

"Chandika Mahawatta" <mc**********@hotmail.com> wrote in message
news:3f*********************@news.frii.net...
I have downloaded third part software, That tool can recover but data
come up with demo, So I believe we should have method to recover it. If
anybody knows please reply...

You can also look up DBCC checkdb but be warned, you will most likely still
lose some data.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #5

P: 1
I had this error on attaching DataBase:

---------------------------
Microsoft SQL-DMO (ODBC SQLState: HY000)
---------------------------
Error 823: I/O error (torn page) detected during read at offset 0x00000027dc2000 in file ....

very cool article about this is here:

http://www.sql.ru/faq/faq_topic.aspx?fid=123

but this article is on russian. If need I can translate it to English.

I repaired my corrupted database.
Sep 29 '05 #6

P: 1
Please can you translate this article in english ?

Thanks
Sylvain
Oct 10 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.