Re: repairing damaged sql server MDF and LDF files

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 20:27:45 +0530

Hi,

Can you post the error you are getting while attaching the database.
If the MDF file is corrupted you have to either contact Microsoft product
support or restore from a valid full backup and restore the subsequent
transaction log backups in sequence.

Note:

During this situation even if you recover the database data integrity will
be lost. I recommend you to restore from full backup.

Thanks
Hari
MCDBA

"SummerCoke" <SummerCoke@discussions.microsoft.com> wrote in message
news:C9AE06CD-460C-48C6-8510-4E1C1858FAE9@microsoft.com...
> Hi All,
>
> My SQL server's data files all corrupted during a severe power failure, we
manage to get back the data files and reinstall the sql server. but
unforunately we failed to attaching the database back to the server. The
error message indicating it is caused by corrupted MDF or LDF files.
>
> Is there a way to perform a file level repair before we can attach it back
to sql server again ?
>
> Any help is very much appreciated.
>
> Bernard Gh

Quantcast