数据库损坏。恢复可能吗？ [英] Corrupted database. Recovery possible?
问题描述
这是一个很长的镜头...
当我今天正在使用Access 2000 mdb（使用2002，但是2000格式）时，Access意外关闭了自己（我没有想法为什么，我只是运行一个相当标准的查询）。当它试图重新打开mdb时，我收到它已损坏的消息 - 具体来说：
" Microsoft Access已检测到此文件中的损坏。要尝试修复此损坏，请首先备份该文件。然后，在工具菜单上，指向数据库实用程序，然后单击压缩和修复数据库。如果您正在尝试修复此损坏，那么您将需要重新创建此文件或从之前的备份中恢复它
我立即备份它，运行Compact和Repair - 这样做也是如此信息。我尝试创建一个新的mdb并导入相同的消息。我尝试从命令行反编译同样的消息。我从微软下载并运行了Jet Compact工具 - 这失败了。
我使用Stellar Phoenix Access Recovery取得了部分成功 - 使用这个我设法恢复表和查询，但不是表格，报告或模块。
我的经理在线联系了一个恢复服务并向他们发送了文件，他们说他们只能恢复相同的状态。
我们的服务器支持团队刚刚告诉我，我正在工作的服务器上的每日备份现在还没有发生几个月（我不知道的事情，不幸的是取决于以下情况：像这样的问题。
TBH我感到恶心 - 这代表了大约2或3个月的工作！
有没有希望在所有？
This is a long shot...
While I was working on an Access 2000 mdb today (using 2002, but 2000 format), Access unexpectedly closed itself (I have no idea why, I was just running a fairly standard query). When it tried to reopen the mdb, I get the message that it is corrupt - specifically:
"Microsoft Access has detected corruption in this file. To try to repair this corruption, first make a backup of the file. Then, on the tools menu, point to database utilites, then click compact and repair database. If you are trying to repair this corruption then you will need recreate this file or restore it from a previous backup"
I immediately backed it up, ran Compact and Repair - this threw the same message. I tried creating a new mdb and importing, same message. I tried decompiling from the command line, same message. I have downloaded and run the Jet Compact tool from Microsoft - this failed.
I have had partial success using Stellar Phoenix Access Recovery - using this I managed to recover tables and queries, but NOT forms, reports or modules.
My manager has contacted a recovery service online and sent them the file and they say they can only recover the same.
Our server support team have just told me that the daily backups on the server I''m working on haven''t been happening for a few months now (something I was not aware of and unfortunately was depending on in case of a problem like this).
TBH I feel sick - this represents about 2 or 3 months of work!
Is there any hope at all?
推荐答案
...这代表了大约2或3个月的工作！ ...
... this represents about 2 or 3 months of work! ...
不正确。
根据我的经验重新编码，你已经从头开始编码了你在不到1/5的时间内获得了更好的代码。 ：D
对于bytes.com上的1个月开发日志一无所知
Not true.
According to my experience recoding the same you''ve already coded from scratch gives you a better code within less than 1/5 of a time it has taken before. :D
To say nothing about 1-month development log on bytes.com
公平评论。
那么没有恢复的希望吗？
Fair comment.
Is there no hope of recovery then?
你可以等到弥赛亚来请他复活你的申请。
:)
说真的。在你的位置，我很高兴获救数据。
You could wait until Messiah come and ask him to resurrect your application.
:)
Seriously. Being on your place, I would be happy having rescued data.
这篇关于数据库损坏。恢复可能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
