repair torn page?

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?
>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|||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" <bericks999@.yahoo.com> wrote in message
news:6c6096fb.0408201308.7e1a5645@.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?|||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!