当前位置：首页 -> 基础 -> 数据库编程

数据库备份还原顺序关系(环境:MicrosoftSQLServer2008R2)(二)

2015-02-03 11:52:29 · 作者: · 浏览: 45
标签: 数据库 备份 还原 顺序 关系 环境 :MicrosoftSQLServer2008R2
K='d:\5.dif' WITH NORECOVERY RESTORE LOG db FROM DISK='d:\6.trn' WITH NORECOVERY RESTORE LOG db FROM DISK='d:\7.trn' --查看 SELECT * FROM db.dbo.Test /* ID 1 2 3 4 5 6 7 */ go --1.8.2 RESTORE DATABASE db FROM DISK='d:\0.bak' WITH REPLACE,NORECOVERY RESTORE LOG db FROM DISK='d:\1.trn' WITH NORECOVERY RESTORE LOG db FROM DISK='d:\2.trn' WITH NORECOVERY RESTORE LOG db FROM DISK='d:\4.trn' WITH NORECOVERY RESTORE LOG db FROM DISK='d:\6.trn' WITH NORECOVERY RESTORE LOG db FROM DISK='d:\7.trn' --查看 SELECT * FROM db.dbo.Test /* ID 1 2 3 4 5 6 7 */