从数据库文件（.mdf 和 .ldf）恢复丢失的数据时出现问题
最近，我们的一位客户从表中删除了 200 万行。
这里的问题是数据库没有备份。我只有主数据文件 (.mdf) 和日志数据文件 (.ldf)。
我下载了一些 Sql 工具的演示版本，通过它我可以打开 .mdf 文件。当我使用 Sql 工具打开 .mdf 文件时，所有丢失的数据都在 .mdf 文件中，但我无法从工具中保存或导出 .mdf 文件中丢失数据的视图，直到我购买它。
我按照 MSDN 和各种网站上显示的许多步骤进行恢复，但都失败了。任何人都可以帮助我，恢复已删除数据并放入 .ldf 文件的最佳过程是什么。 我提到的恢复数据的站点之一是 恢复丢失的数据
Recently, one of our clients has deleted two million rows from a table.
Here the problem is the database is not taken backup. I have only the master data file (.mdf) and Log data file (.ldf) with me.
I have downloaded some demo version of Sql tool, through which i am able to open the .mdf file . When i opened the .mdf file using the Sql tool all the lost data is there in the .mdf file but i cant save or export the view of the Lost data from .mdf file from the tool until i purchase it.
I had followed many steps that has shown in MSDN and various websites to recover but with all a failure. Can any one help me, what is best process to recover the deleted data and put in .ldf file.
One of the Sites which I have referred to recover the data is Recover Lost Data
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
丢失数据的成本是多少？随着时间的推移，丢失数据的成本是多少？也就是说，数据丢失的时间越长，损失就越大吗？将此成本与您发现（显然）有效的工具的成本进行比较，并考虑到它已经和正在花费您寻找不同解决方案的时间成本。看来，除非他们收取的费用高得离谱[你能发布产品和成本吗？]，否则你最好硬着头皮付钱给他们，并正确使用产品离开，如果不起作用，则提供（隐式）退款保证。
另一种选择是获取一个事务日志读取程序，该程序可以读取和处理事务日志中存储的数据...但如果您不进行备份，那么您的数据库（希望如此！）处于简单恢复模式，并且取决于您的数据库有多活跃，数据可能早已从事务日志中删除。然而，我听说过的所有此类程序也都有许可费。
因为是的，从 SQL Server 数据库恢复已删除的数据是一件很难的事情。
What is the cost of losing the data? What is the cost over time of losing the data--that is, is it more and more the longer the data remains lost? Compare this cost with the cost of the tool you have found that (apparently) works, and factor in the cost of the time it has and is taking you to find a different solution. It seems likely that, unless they're charging ridiculous amounts of money [can you post the product and cost?], you'd be better off biting the bullet, paying them, and using the product right away, with the (implicit) guarantee of a refund if it doesn't work.
Another option is to get a transaction log reading program that can read and work with data stored in the transaction log... but if you're not doing backups, then your databases are (hopefully!) in Simple recovery mode, and depending on how active your databases are that data may have long-since been dropped from the transaction log. However, all such programs that I've heard about also have licensing fees.
Because yes, recovering deleted data from a SQL Server database is a hard thing to do.