SQL Server的还原分析和总结.docxVIP

SQL Server 的还原 差异备份的还原 不备份结尾日志的情况下还原数据 下面我们给出差异备份与还原的 T-SQL 方法，代码如下： --创建备份设备 EXEC sp_addumpdevice disk, MyAdvWorks_1, d:\backup\MyAdvWorks_1.bak; EXEC sp_addumpdevice disk, MyAdvWorks_diff1, d:\backup\MyAdvWorks_diff1.bak; EXEC sp_addumpdevice disk, MyAdvWorks_log1, d:\backup\MyAdvWorks_log1.bak; EXEC sp_addumpdevice disk, MyAdvWorks_log2, d:\backup\MyAdvWorks_log2.bak; --数据库备份阶段 -- 创建完整备份 BACKUP DATABASE MyAdvWorks TO MyAdvWorks_1 WITH INIT; GO -- 在完整备份之后创建差异备份 BACKUP DATABASE MyAdvWorks TO MyAdvWorks_diff1 WITH DIFFERENTIAL; GO --数据库还原阶段 -- 完整还原 RESTORE DATABASE MyAdvWorks FROM MyAdvWorks_1