Probably corrupted MDF ans/or LFD

A customer of mine did power-off its Desktop PC without closing Windows (ME). After restart, an important database (account data of its job) under MSQL Desktop Edition (SQL 7) got unaccessible.

Trial 1) I tried to attach the mdf/ldf files, getting an error and aborting the procedure
Trial 2) I tried to create a new database with the same name and the same filegroup properties. I stopped SQL Server and overwrote the files. This way I could see a grey database Icon with the "(Suspect)" postfix. No items could be browsed for that database.
Trial 3) Then I tried to apply the procedures I found in the Microsoft documentation (sp_resetstatus, DBCC CHECKDB ALLOW_DATA_LOSS...) without any result.

Could you help or suggest something?
Thanks
francotiveronAsked:
Who is Participating?
 
arbertCommented:
francotiveron, what's the status on this question???
0
 
arbertCommented:
You have a backup right--restore it.

You should never use sp_resetstatus when you know the data is probably corrupt or actually suspect.
0
 
francotiveronAuthor Commented:
I have only the MDF and LDF.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
arbertCommented:
hmmm, if the MDF and LDF are corrupt, there isn't too much you can do.  Probably a good time to plan future backups....
0
 
francotiveronAuthor Commented:
This is what I hated. My customer started to reinput data starting from last backup (three weeks!)
0
 
francotiveronAuthor Commented:
Probably it is already known, but I tried the demo of a recovery tool: MSSQLRecovery (www.officerevocery.com/mssql/)
0
 
francotiveronAuthor Commented:
0
 
arbertCommented:
So if the client is reinputting data I take it the product wasn't that great????
0
 
francotiveronAuthor Commented:
The customer preferred to reinput date because the product costs 499 $. The demo version reads the MDF file and gives a lot of sql files with data. The first rows contain true data, but the remaining contain "Demo" fixed string, so it is not possible to evaluate if that tool recover all data from corrupted DB. Anyway, it seems good.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.