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
Answers (3)
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.
No disk monitoring? No shadow copy? No back-up? You must love life on the edge!
Have you seen this?
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.