Server Management Question

SQL Server 2000 Cannot Attach Database, Problem with LDF File

06/23/2015 2203 views

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

Answer Summary:
0 Comments   [ + ] Show comments


Answer Chosen by the Author


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.

Answered 06/25/2015 by: haaniomar
White Belt

All Answers


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

Have you seen this?

Answered 06/25/2015 by: VBScab
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.
Answered 06/25/2015 by: h2opolo25
Red Belt

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