Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2015
    Posts
    1

    Unanswered: SQL Server 2000 Cannot Attach Database, Problem with LDF File

    We are trying to attach a database but it doesn't like the ldf files (there are 2).
    One of the ldf files grew too large and became corrupt when we ran out of disk space.

    We have renamed the log files, no luck.
    We have moved the log files off the computer, no luck.

    Can you delete the reference to the ldf files in the mdf file?

    Or are there any other suggestions?

    Thank you in advance

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't know of any way to fix this using the GUI, but if you can write a simple query then you have a chance.

    Make a backup copy of your MDF file
    and take that backup offline before you try this!


    Read the destructions at https://technet.microsoft.com/en-us/...sql.80%29.aspx and follow them precisely. This is pretty safe if you do it correctly, but it has the ability to do really bad things if you do anything wrong!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    May 2016
    Posts
    1
    Recommended actions for corrupt or suspect databases is a guide below and informative threads with bonus solution, which created for very complicated cases with .mdf files MDF Open File Tool

  4. #4
    Join Date
    Jan 2016
    Posts
    24
    Provided Answers: 1
    If you want to attach a mdf without ldf then you can take the help of this link: http://www.sqlserverlogexplorer.com/...hout-ldf-file/ this shows step by step method to attach mdf without ldf file using sql server management studio and transact-sql.

    However if you want to recover corrupt ldf file then you must go with third party tools like: SQL LDF File Reader

  5. #5
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1
    Hi Sanchomosso,

    You can attach the .MDF file without .LDF file by following ways:
    •Using SQL Server management Studio
    •Using T-SQL script

    Read the following article and follow the steps.

    If you unable to do so that means your SQL Server database has been corrupted. To repair your corrupt database, you should try Stellar Phoenix SQL Database Repair tool. Download its demo version and try on your corrupt database.

    Good Luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •