Re: repairing damaged sql server MDF and LDF files

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Relevant Pages

  • Re: "Hidden" Replication Stored Procedures?
    ... Since the engine has hooks that hide the mssqlsystemresource database from ... 4.)Start the SQL Server service; ... Chris Jones ... aforementioned MDF file in Notepad and doing a quick search, ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem with updating MDF Data file as opposed to updating a running SQL Server DB
    ... In Visual C# Express, I created a windows application, then "Added" a ... Doing this created an MDF file in my project folder, ... database into my database explorer window in the IDE. ... It would seem with this option, then one could use a SQL Server MDF ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: A question about understanding the mdf database file
    ... Service-based Database which will create a mdf file. ... I must have the SQL server express service running otherwise I get ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ASPNETDB.MDF when no SQLExpress, only SQL Server 2005?
    ... You will need to upload the mdf file and have your webhost attach it to the sql server. ... In which case you will need to recreate the database into the database which is available to the hosted domain if you have signed up ... The connection will be closed. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Error 823
    ... Regards. ... Microsoft SQL Server Storage Engine ... > I cannot extract much data out of the database and I can't view the most ... The problem is in the .MDF file, ...
    (microsoft.public.sqlserver.tools)