Error 823
From: Marco Pais (mpais_at_foruminformatica.pt)
Date: 05/21/04
- Next message: QMBG: "Problems with SQL2000 Install"
- Previous message: Douglas Lane: "RE: Registration Failed - Not associated with a trusted SQL Server Connection"
- Next in thread: Tibor Karaszi: "Re: Error 823"
- Reply: Tibor Karaszi: "Re: Error 823"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 21 May 2004 20:41:33 +0100
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
- Next message: QMBG: "Problems with SQL2000 Install"
- Previous message: Douglas Lane: "RE: Registration Failed - Not associated with a trusted SQL Server Connection"
- Next in thread: Tibor Karaszi: "Re: Error 823"
- Reply: Tibor Karaszi: "Re: Error 823"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
