22,207
社区成员
发帖
与我相关
我的任务
分享
----先进行完全备份
backup database dbname to 'e:\a.bak'
----在E盘备份一个差异备份
backup database dbname to 'e:\b.bak' with differential
----在F盘备份一个差异备份
backup database dbname to 'f:\b.bak' with differential
----还原时根据备份的先后顺序还原
--先还原完全备份
restore database dbname from disk='e:\a.bak' with norecovery
----然后按照差异备份的先后顺序还原
restore database dbname from disk='e:\b.bak' with norecovery
restore database dbname from disk='f:\c.bak' with recovery