Probably corrupted MDF ans/or LFD
Posted on 2003-11-14
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?