日志还原的需要,用LiteSpeed的时候,能够查找到相应日志文件的 FirstLsn LastLsn CheckpointLsn DifferentialBaseLsn (例如:master.dbo.xp_restore_headeronly @filename='e:\BackUp\172.17.0.12\SMT\SMT_LOG20081005.TRN') ,但有时候还原不成功,要不就是Log中的LSN比当前数据库中的LSN 小,要不就是大,所以想查找当前数据库中的LSN。
调试欢乐多
DBCC CHECKDB
检查指定数据库中的所有对象的分配和结构完整性。然后使用完全备份,然后再还原.
00004fe2:00001d9f:0001 LOP_END_CKPT LCX_NULL 0000:00000000 0x0000 136 136 00004fe2:00001d9e:0001
00004fe2:00001da0:0001 LOP_END_RECOVERY LCX_NULL 0000:00000000 0x0000 24 24 00004fe2:00001d0c:0001
dbo.xp_restore_headeronly @filename='e:\BackUp\172.17.0.12\SMT\SMT_LOG20081005.TRN'
中显示:
FirstLsn LastLsn CheckpointLsn DifferentialBaseLsn 170372000001789200001 170442000000003500001 170391000000609300173 167028000000438700299
170442000000003500001 170558000000113300001 170557000002536300001 167028000000438700299
170558000000113300001 170584000002030700001 170583000001315300048 167028000000438700299
170584000002030700001 170610000000849600001 170609000000358700011 167028000000438700299
170610000000849600001 170630000002251000001 170630000000823000001 170620000000285600268
170630000002251000001 170646000001577600001 170646000000778400011 170620000000285600268
170646000001577600001 170659000001639200001 170659000001219300009 170620000000285600268
170659000001639200001 170664000001117600001 170659000001989800001 170620000000285600268
170664000001117600001 170703000001940200001 170703000001766600001 170620000000285600268能否给出他们的关系?
再给分
给出 00004fe2:00001d9f:0001 的结构,100分
-------------------------------------------------------------
(1)基于完全备份。
(2)为递增备份,即备份从上一次备份以来到备份时所写的事务日志。
(3)允许恢复到故障时刻或者一个强制时间点。
(4)恢复时,需要应用完全备份和完全备份后的每次日志备份。
-------------------------------------------------------------
backup database d3 to bak3 with init,name='d3_full' --日志备份,第一次备份时应做完全备份
create table b1(c1 int not null,c2 char(10) not null)
backup log d3 to bak3 with
insert b1 values(1,'a')
backup log d3 to bak3 with
insert b1 values(2,'b')
backup log d3 to bak3 with
insert b1 values(3,'c')
backup log d3 to bak3 with
restore headeronly from bak3
----------------------------------------------------------------------
create table b1(c1 int not null,c2 char(10) not null) --Full+Log+Diff
backup log d4 to bak4 with
insert b1 values(1,'a')
backup log d4 to bak4 with
insert b1 values(2,'b')
backup database d4 to bak4 with differential,name='d4_diff1'
insert b1 values(3,'c')
backup log d4 to bak4 with
insert b1 values(4,'d')
backup log d4 to bak4 with
insert b1 values(5,'d')
backup database d4 to bak4 with differential,name='d4_diff2'
restore headeronly from bak4
----------------------------------------------------------------------