查明数据库备份的时间 [英] Find out when a database backup was made

问题描述

Folks，

假设您收到SQL Server数据库的断开连接的备份（2005或2008），并将其还原到SQL Server实例。

Assume you receive a disconnected backup of a SQL Server database (2005 or 2008) and you restore that to your SQL Server instance.

有没有办法，有没有系统目录或东西，以找出什么时候最后一次写操作发生在该特定数据库？我想要能够找到一个特定的数据库备份是什么 - 不幸的是，这不是真正被明确记录在任何地方，检查所有数十个数据表的最高日期/时间戳不是真的一个选择....

Is there a way, is there a system catalog or something, to find out when the last write operation occured on that particular database? I'd like to be able to find out what day a particular database backup was from - unfortunately, that's not really being recorded explicitly anywhere, and checking all dozens of data table for the highest date/time stamp isn't really an option either....

有什么想法吗？当然 - 我可以看看* .bak文件的日期/时间戳 - 但我可以从SQL Server（Management Studio）中找到更精确的

Any ideas? Sure - I can look at the date/time stamp of the *.bak file - but can I find out more precisely from within SQL Server (Management Studio) ??

谢谢！
Marc

Thanks! Marc

推荐答案

您可以尝试 RESTORE HEADERONLY 备份文件，如此处所述

You can try RESTORE HEADERONLY on your backup file, as described here

，应该能提供您正在寻找的信息。

that should give you the information you're looking for.

这篇关于查明数据库备份的时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！