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

repair torn page?

P: n/a
I have inherited a poorly administered/maintained database that
contains the following error:

"I/O error (torn page) detected during read at offset 0x000018ee23e000
in file 'F:\Program Files\ISS\RealSecure SiteProtector\Site
Database\Data\RealSecureDB.mdf"

I do not have database backups and so therefore cannot restore from
them. I want to move the database to a new platform and somehow
repair the torn page. Is this possible?
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

I have inherited a poorly administered/maintained database that
contains the following error:

"I/O error (torn page) detected during read at offset 0x000018ee23e000
in file 'F:\Program Files\ISS\RealSecure SiteProtector\Site
Database\Data\RealSecureDB.mdf"

I do not have database backups and so therefore cannot restore from
them. I want to move the database to a new platform and somehow
repair the torn page. Is this possible?


If you want to get your data out of this damaged database, we can help
you. Have a look at www.sql-server-repair.com

The error message you got indicates that a data page (8kByte) has not
been written completely. So at this page will be some data loss.
Regards

Thilo Immel
The SQL Sevrer Druid www.sql-server-repair.com


Jul 20 '05 #2

P: n/a
You might try DBCC CHECKDB, if you haven't already done so. The end of the
report will suggest the DBCC CHECKDB repair option needed to correct the
problem. As Thilo said, this will likely be REPAIR_ALLOW_DATA_LOSS due to
the torn page. See the Books Online for more information.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"bbbad_999" <be********@yahoo.com> wrote in message
news:6c**************************@posting.google.c om...
I have inherited a poorly administered/maintained database that
contains the following error:

"I/O error (torn page) detected during read at offset 0x000018ee23e000
in file 'F:\Program Files\ISS\RealSecure SiteProtector\Site
Database\Data\RealSecureDB.mdf"

I do not have database backups and so therefore cannot restore from
them. I want to move the database to a new platform and somehow
repair the torn page. Is this possible?

Jul 20 '05 #3

P: n/a
see
http://www.nigelrivett.net/RecoverCorruptDatabase.html

Nigel Rivett
www.nigelrivett.net

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

This discussion thread is closed

Replies have been disabled for this discussion.