Sql无法识别mdf文件 [英] Sql does not recognize mdf file

问题描述

SQL今天已经停止识别MDF文件。

也许是因为某些系统故障而损坏了。如何恢复未被识别为主文件的MDF文件？



我尝试过：



没有采取任何措施不破坏文件而不是搞砸了。）

SQL have ceased to recognize the MDF file today.
Perhaps due to some system failure it damaged. How can I restore the MDF file that is not recognized as the primary file?

What I have tried:

No action was taken that not to break the file and not to screw things up.)

推荐答案

引用：

也许是由于某些系统故障而导致其损坏。如何恢复未被识别为主文件的MDF文件？

Perhaps due to some system failure it damaged. How can I restore the MDF file that is not recognized as the primary file?

使用上次备份并恢复数据库。

如果没有备份，则可能丢失了所有内容。

Use last backup and restore the database.
If you don't have backups, you probably have lost everything.

如果您的MDF文件已损坏或格式无法识别，那么您必须使用某些第三方工具来修复它，例如MDF Repair Kit或其他一些工具。您可以在Google中搜索。 http://www.mdf.repair/



但你可以如果没有严重损坏，请尝试自行恢复文件。

来自损坏的mdf文件的数据可以通过以下方法恢复：



使用 DBCC CHECKDB修复MDF文件：

Microsoft提供了一个名为 DBCC CHECKDB 的命令，当你运行它然后它试图检测&修复所有可能的错误消息。如果它无法修复错误消息，则建议修复条款。

使用suggest repair子句重新运行命令。你的问题可能会得到解决。但是，在此之后你可能会丢失一些数据。

If your MDF file was corrupt or in unrecognizable format then you have to use some third party tools to sql mdf repair it out for example like MDF Repair Kit or some others. You can search in Google. http://www.mdf.repair/

But you can try to restore the file by yourself if it is not badly damaged.
Data from corrupt mdf file can be recovered by following method:

Repair MDF file with DBCC CHECKDB:
Microsoft offers a command that is known as DBCC CHECKDB, when you run this then it try to detect & fix all the possible error message. If it fails to fix error message then it suggest repair clause.
Re-run the command with suggest repair clause. Your problem might be solved. But, you may loss some amount of data after this.

哦，很难过，因为我的备份很旧。但无论如何，谢谢你的答案！）

Oh, it's sad, because my backup is quite old. but thanks anyway for the answer!)

这篇关于Sql无法识别mdf文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！