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=5,recovery

select * from soft..t

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!