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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

1

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

Please log in to comment

Answers

0

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

Please log in to comment
0
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

Please log in to comment
Answer this question or Comment on this question for clarity