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!

Reordering SQL Tables

Hi,

I have inherited an inhouse employee self service application used to display various employee data.

I have one table that needs to have the data permanently reordered, as the front end web page reads the data from the table from the top to the bottom, but somehow this data has got mixed up and is not in the sequential order that it should be in.

I am new to SQL and haven't a clue how to change the web code, so was hoping I could run a script on that table to reorder the data in an ascending manner on one of the columns.

Is this possible? How can I do this?

Thanks

Chris

Hi Chris,

When you say "not in the sequential order" do you mean there is a column that has incrementing numeric values such as 1,2,3...100000 or that you expect results to be ordered by something like customer name etc?

You can only "order" a table via a clustered index, but this has no impact upon client query result formats (in fact it did pre 2000 if no order by was specified, but that's another story). You will need to specify an ORDER BY in the client, or in a view (via the TOP clause) or stored procedure. You cannot rely upon sql server to return ordered results unless you have explicity stated what and how you wish the ordering to ocurr.

Cheers,

Rob