如何在字段sql-2008中获取旧数据 [英] how to get old data in field sql-2008

问题描述

昨天我更新了数据库一个字段中的一些数据，如何使用sql-2008在该特定字段中获取旧数据.任何人告诉我如何获取该旧数据

yesterday i updated some data in database one field how to get old data in that particular field am using sql-2008 any one tell me how to get that old data

推荐答案

如果有备份，可以从那里检索.
如果您不这样做，那么该过程将变得非常艰巨，您应该优先考虑实施备份系统.

基本上，如果您没有备份，则将无法通过事务日志检索数据.有一些公司可以为您提供帮助- http://www.apexsql.com/sql_tools_logapi.aspx [ ^ ]可以免费试用14天，这可能足以恢复您的数据.

然后备份！

If you have a backup, you can retrieve it from there.
If you don''t then the process gets much, much harder, and you should consider implementing a backup system as a matter of priority.

Basically, if you don''t have a backup, you are stuck with retrieving the data through the transaction log. There are companies that can help you - http://www.apexsql.com/sql_tools_logapi.aspx[^] have a free 14 day trial, which may be enough to get your data back.

And then BACKUP!

这篇关于如何在字段sql-2008中获取旧数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！