sqlserver2005备份还原

事务日志备份：

backup log dbname to where

 

insert into soft..t values (3,'44',444);

backup log soft to softbak

还原：

drop database soft

restore headonly from softbak

 

restore database soft from softbak with file=1,norecovery

restore database soft from softbak with file=3,norecovery

restore database soft from softbak with file=4,recovery

 

select * from soft..t

insert into soft..t values (5,'555',54)

backup log soft to softbak

drop database soft

restore headonly from softbak

restore database soft from softbak with file=1,norecovery

restore database soft from softbak with file=3,norecovery

restore database soft from softbak with file=4,norecovery

restore database soft from softbak with file=5,recovery

select * from soft..t