Hello.

I pray to that someone can help me...

A month ago a compaq server hosting a SQL Server 2000 Server had a hardware
crash. Unfortunatly, the Compaq Smart Array was configured with RAID 0.

Aparently the problem was there a long time ago and there was not a recently
backup file. So, we've delivered the Raid System to a Recovery company.

The data was recovered, I have the .MDF and the .LDF files. The problem is,
after i attach the database to a clean instance of Sql Server, i get the
following error:

******************
Server: Msg 823, Level 24, State 2, Line 1
I/O error (bad page ID) detected during read at offset 0x0000001ef3c000 in
file 'D:\Data\database_Data.MDF'.

Connection Broken
******************

I've tried several possible solutions as CHECKDB, CHECKALLOC and so far,
with no results.

How can I resove this problem? I have read thousands of Forum messages but
i've no solution. I have read Microsoft Knowledge Base Article 826433, that
tells me that there are a build of Sql server, wich have several tools to
try to correct this problem. Tha leads me to another problem.... i cannot
find that file versions.

I would thanks any solution, any help.

Regards.

Marco Pais

You cannot just attach .mdf and .ldf files. They have to be detached first.
If you have a support contract with MS may be it is a time to call.

"Marco Pais" <mpais (AT) foruminformatica (DOT) pt> wrote