数据库恢复过程 ,完整/差异/日志.

来源：互联网发布：包小三选股软件编辑：程序博客网时间：2024/06/05 15:09

--列出备份文件中的数据文件.恢复时好指定移动位置
RESTORE FILELISTONLY From disk = 'D:\DataTmp\ZJSYCADDB.bak'
drop database caddb
go
--恢复全备份
restore database caddb from disk= 'D:\DataTmp\ZJSYCADDB.bak' with norecovery,replace,
move 'NEWGFCAD_Data' to 'D:\DataTmp\caddb\caddb.mdf',
move 'NEWGFCAD_Log' to 'D:\DataTmp\caddb\caddblog.ldf'
--恢复差异备份
restore database caddb from disk='D:\DataTmp\ZJSYCADDB33diffb.bak' with norecovery
--恢复日志, 多个日志的时修要注意,前面的只能用norecovery,最后一个用recovery
--从差异备份起,到指定日志前的所有日志都需要恢复.
restore log caddb from disk= 'D:\DataTmp\ZJSYCADDB410_22.log' with norecovery
restore log caddb from disk= 'D:\DataTmp\ZJSYCADDB410_23.log' with norecovery
restore log caddb from disk= 'D:\DataTmp\ZJSYCADDB410_24.log' with norecovery
restore log caddb from disk= 'D:\DataTmp\ZJSYCADDB410_25.log' with norecovery
restore log caddb from disk= 'D:\DataTmp\ZJSYCADDB410_26.log' with recovery,
stopat= '2013-12-25 13:20:00' ,
--时间点可以根据需要调整

0 0