存档

文章标签 ‘with until_time’,文章数:1

load transaction with until_time执行失败

在测试load tran with until_time 的时候出现了错误。

先执行：dump tran andkylee to "d:\andkylee_tran2.dmp" with no_truncate 然后，进行数据库的恢复。

先进行全库恢复，接着进行下面的日志恢复，并恢复到指定的时间点。

但是报下面的错误：

1> load tran andkylee from "d:\andkylee_tran2.dmp" with until_time='Jun 28 2010 5:24:10 PM'
2> go
Backup Server session id is:  111.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'ndkylee101790F554' section number 1
mounted on disk file 'd:\andkylee_tran2.dmp'
Backup Server: 4.58.1.1: Database andkylee: 75548 kilobytes LOADed.
Msg 623, Level 21, State 1:
Server 'TEST', Line 1:
Adaptive Server failed to retrieve a row via its RID in database 'andkylee'
because the target page is not a data page. Rid pageid = 0x16381; row num = 0x0.

Page pointer = 0x240FA000, pageno = 0, status = 0x300, ptnid = 99, indexid = 0,
level = 0.

用dbcc page查看pageid = 0x16381 的页面内容，发现此页面为日志页。页面号0x16381为十六进制，转化成十进制为：91009

阅读全文...

标签: , ,