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

0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
Posted by: haaniomar 5 years ago
White Belt

Top Answer

Restore sql database via management studio, if not make use of morestrenghten method for severely corrupted sql databaseshttp://www.mdf.openfiletool.com/ MDF Open File Tool


1. Open your SQL Server Management Studio console. This applicationshortcut is available in the SQL Server directory in the Windows Start button.

2. Enter the system administrator user name and password. SQL Server'sadministrator user name is "sa." This account is required forprivileges to restore the database. If your restoring on a host providerserver, use the administrator user name and password they supplied for youraccount.

3. Right-click your database name and select "Attach." In thenew window that opens, click the "Add" button to open a dialog box.

4. Select your MDF file and press the "Ok" button. It may takeseveral minutes to restore the database if it is a large file. Once the processis finished, browse your tables to verify the data. The database is nowrestored.

Posted by: anonymous_9363 5 years ago
Red Belt

No disk monitoring? No shadow copy? No back-up? You must love life on the edge!

Have you seen this?

Posted by: h2opolo25 5 years ago
Red Belt
You can try a brand of SQL Recovery Software and see if that gets you anywhere for this instance but you should really have backups of your database and recover from there.

Not sure about SQL 2000 but you can try to restore the database to a specific point in time where the logs are not used. Obviously you will loose whatever changes were made from that point forward.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ