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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
francotiveronAuthor Commented:
I have only the MDF and LDF.
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....
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

arbertCommented:
francotiveron, what's the status on this question???

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
francotiveronAuthor Commented:
This is what I hated. My customer started to reinput data starting from last backup (three weeks!)
francotiveronAuthor Commented:
Probably it is already known, but I tried the demo of a recovery tool: MSSQLRecovery (www.officerevocery.com/mssql/)
francotiveronAuthor Commented:
arbertCommented:
So if the client is reinputting data I take it the product wasn't that great????
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.