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

事务日志备份：

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

总结

以上是内存溢出为你收集整理的sqlserver2005备份还原全部内容，希望文章能够帮你解决sqlserver2005备份还原所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。