-
公开(公告)号:US20050223043A1
公开(公告)日:2005-10-06
申请号:US10814459
申请日:2004-03-31
申请人: Paul Randal , Michael Zwilling
发明人: Paul Randal , Michael Zwilling
CPC分类号: G06F17/30315 , G06F11/1458 , G06F2201/80 , G06F2201/82 , Y10S707/99953 , Y10S707/99955
摘要: A method for performing a consistency check on a database backup of a database is performed without requiring a full recovery of the original database from the database backup. Instead, a database view may be used as a smaller storage requirement tool for providing a transaction-consistent view of portions of an existing full database backup. The database view, in combination with the database backup and transaction log, contains all the information necessary to perform a consistency check on the database backup without a full reconstitution of the original database from the database backup. The consistency check may be run on the database view along with the database backup to verify the integrity of the full database backup to add improved reliability to a database recovery scheme.
摘要翻译: 执行用于对数据库的数据库备份进行一致性检查的方法,而不需要从数据库备份完全恢复原始数据库。 相反,数据库视图可以用作较小的存储需求工具,用于提供现有完整数据库备份的部分的事务一致视图。 数据库视图与数据库备份和事务日志相结合,包含对数据库备份执行一致性检查所需的所有信息,而无需从数据库备份完全重新构建原始数据库。 一致性检查可以与数据库备份一起在数据库视图中运行,以验证完整数据库备份的完整性,从而为数据库恢复方案增加可靠性。
-
公开(公告)号:US20060218144A1
公开(公告)日:2006-09-28
申请号:US11091080
申请日:2005-03-28
申请人: Paul Randal
发明人: Paul Randal
IPC分类号: G06F17/30
CPC分类号: G06F17/3051 , G06F11/0751 , G06F17/30342 , Y10S707/99932 , Y10S707/99942 , Y10S707/99944
摘要: The subject invention relates to systems and methods that perform consistency checks of user defined type (UDT) fragments utilizing a stream of data without wholesale copying of the data. Streaming consistency checks facilitate discovering invalid fragments as soon as possible such that the entire UDT fragment does not have to be read, stored, analyzed, etc. Additionally, a UDT fragment can be evaluated without being completely materialized; thus, systems and/or methods employing the subject invention can yield improved performance as compared to conventional techniques by reducing required resources and enabling faster detection of invalid structures.
-