---------------------------------------------------------------------------
---- 本文为andkylee个人原创,请在尊重作者劳动成果的前提下进行转载;
---- 转载务必注明原始出处 : http://blog.csdn.net/andkylee
--- 2010-06-28 17:42:40
---- 关键字: ase dump transaction load until 日志恢复 错误 retrieve a row via its RID
----------------------------------------------------------------------------
在测试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
ptnid=8 syslogs
不指定时间点了,全部恢复日志备份文件,竟然成功了!但是,不是想要的结果!
推断,在until_time='Jun 28 2010 5:24:10 PM'时间点附近的日志备份文件中有逻辑页面错误。
尝试挪动时间点能否恢复成功!