Re: Error 823

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 05/22/04 

Date: Sat, 22 May 2004 09:36:23 +0200

Please don't repost the same question over and over again. You've already gotten some advice, even from Paul
R, which most likely is the most qualified person in the world regarding these issues. I strongly advice you
to follow Paul's advice and let MS help you with this (open a support case). 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Pais" <mpais@foruminformatica.pt> wrote in message news:ONk4hu2PEHA.3660@TK2MSFTNGP11.phx.gbl...
> 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
>
>

Relevant Pages

  • Re: Architecture Advice
    ... >> I'm going to be using SQL Server for a distributed ... >> application and I'd appreciate any advice on architecture. ... >> Simplest approach would be 2-tier client server and be done with it. ... it would be nice to be able to provide some data caching at the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: What do I need to use Terminal Server?
    ... It's taken as offered and all good advice. ... I'm starting to see some major modifications to the overall network setup ... Then, based on what I found in #1, I would order the proper hardware ... and software for you - server, workstations, SQL Server if required, ...
    (microsoft.public.windowsxp.general)
  • Re: newbie question - local queries
    ... Thanks for the advice. ... newbie would pretty much give the idea, that, I am a NEWBIE... ... I have never used SQL Server, but have started reading and studying it. ... local workstation. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Generated fields in CE table
    ... This may have been the most valuable piece of advice I have ever gotten in ... this whole mess. ... Please reference this one C:\Program Files\Microsoft Visual ... >> an article to the publication on the SQL server using enterprise manager. ...
    (microsoft.public.sqlserver.ce)
  • Error 823
    ... A month ago a compaq server hosting a SQL Server 2000 Server had a hardware ... we've delivered the Raid System to a Recovery company. ... I/O error detected during read at offset 0x0000001ef3c000 in ...
    (microsoft.public.sqlserver.dts)