MS SQL 2008如何从日志中读取 [英] MS SQL 2008 HowTo read from log

问题描述

我有一个包含很多行的表，有什么方法可以找到何时插入具体行? (我没有创建/更新时间列)

I have a table with many rows, is there any way to find out when a concrete row has been inserted? (I don't have create/update time columns)

谢谢

推荐答案

否，通常没有日志供用户分析.除非您从头开始对其进行解码，否则它的组织方式也不容易导致获得此信息.另外，由于每次备份后日志都会被删除....即使到那时您都可能不知道，除非您从未进行过备份.

No, generally the log is not there for the user to analyze. it is also not organized in a way leading easily to this information UNLESS you would decode it from the start. Plus, as logs get deleted after every backup.... you may not know even then, unless you never make a backup.

存在日志的唯一原因是在发生灾难时可以将其前滚，以使您的上一次备份达到日志的目的.

The only reason logs exist is to be there to roll forward in case of a disaster, to allow your last backup to get up to the point of the log.

通常，如果您希望将该信息作为表的一部分，则使其成为表的一部分(例如，插入创建/更新时间戳列).

In generally, if you want that information as part of a table, make it part of the table (.e. insert create/update timestamp columns).

这篇关于MS SQL 2008如何从日志中读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！