SQLServer的还原介绍.doc

SQL Server的还原 1.差异备份的还原 下面我们给出差异备份与还原的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 WITH NORECOVERY;