3）事务日志备份

-------------------------

（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

----------------------------------



本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/feixianxxx/archive/2009/07/22/4370448.aspx

------解决方案--------------------
楼主必须先还原完全备份的数据库 再还原差异备份的

------解决方案--------------------
dbcc checkdb('数据库')看看