请帮我看下"同时执行完整备份还原和差异备份还原语句"

Question

看了很多个帖子,发现有些比如完整备份和完整还原后面有加参数,可有些也没加参数,  都搞糊涂了,呵呵以下的理解是不是正确的  
比如: 执行完整备份还原 
Restore Database SQLDB 
From disk='G:\Backup\Full_20090206.bak' 执行差异备份还原 
Restore Database SQLDB 
From disk='G:\Backup\Diff_20090209.bak' 
同时执行完整备份还原和差异备份还原是不是这样的 
Restore Database SQLDB 
From disk='G:\Backup\Full_20090206.bak' 
Restore Database SQLDB 
From disk='G:\Backup\Diff_20090209.bak' 

Answer 1

Restore Database SQLDB 
From disk='G:\Backup\Full_20090206.bak' 
WITH NORECOVERY
Restore Database SQLDB 
From disk='G:\Backup\Diff_20090209.bak' 

Answer 2

同时执行完整备份还原和差异备份还原是不是这样的 
Restore Database SQLDB 
From disk='G:\Backup\Full_20090206.bak' 
Restore Database SQLDB 
From disk='G:\Backup\Diff_20090209.bak' 

Answer 3

WITH NORECOVERY  这个是代表什么意思??

Answer 4

Restore Database SQLDB
From disk='G:\Backup\Full_20090206.bak'
WITH NORECOVERY
Restore Database SQLDB
From disk='G:\Backup\Diff_20090209.bak' 
WITH RECOVERY --如果还要还原日志，需要 WITH NORECOVERY

Answer 5

restore headeronly from bak1
restore database d1 from bak1 with file=2         --从完全备份中恢复
----------------------------------------------------------------------
restore headeronly from bak2              --从差异备份中恢复
restore database d2 from bak2 with file=1,norecovery    
restore database d2 from bak2 with file=5,recovery
----------------------------------------------------------------------
restore headeronly from bak3              --从日志备份中恢复
restore database d3 from bak3 with file=1,norecovery
restore log    d3 from bak3 with file=2,norecovery
restore log    d3 from bak3 with file=3,norecovery
restore log    d3 from bak3 with file=4,norecovery
restore log    d3 from bak3 with file=5,recovery
----------------------------------------------------------------------
restore database d3 from bak3 with file=1,norecovery      --恢复到指定时间
restore log    d3 from bak3 with file=2,norecovery
restore log    d3 from bak3 with file=3,norecovery
restore log    d3 from bak3 with file=4,recovery,stopat='2003-08-15 11:29:00.000'
----------------------------------------------------------------------
restore database d5 filegroup='FG2' from bak5 with file=4,norecovery --还原文件组备份
restore log d5 from bak5 with file=5,norecovery
restore log d5 from bak5 with file=7,recovery
----------------------------------------------------------------------
restore headeronly from bak6                 --还原文件备份
restore database d5 file='d5_data3' from bak6 with file=6,norecovery
restore log d5 from bak6 with file=7,norecovery
restore log d5 from bak6 with file=9,recovery
----------------------------------------------------------------------
restore database d5 from bak6 with replace    --删除现有数据库，从备份中重建数据库
----------------------------------------------------------------------

Answer 6

5楼贴的这些，需要先贴下如何备份的，不然谁知道你file=xxx是什么东东

Answer 7

单独完整备份
SQL codeRestore Database SQLDB 
From disk='G:\Backup\Full_20090206.bak'
WITH RECOVERY
完整备份后追加差异备份
SQL codeRestore Database SQLDB 
From disk='G:\Backup\Full_20090206.bak' 
WITH NORECOVERY 
Restore Database SQLDB 
From disk='G:\Backup\Diff_20090209.bak' 
WITH RECOVERY
完整备份后追加差异备份再追加日志
SQL codeRestore Database SQLDB 
From disk='G:\Backup\Full_20090206.bak' 
WITH NORECOVERY 
Restore Database SQLDB 
From disk='G:\Backup\Diff_20090209.bak' 
WITH NORECOVERY
Restore Database SQLDB 
From disk='G:\Backup\Diff_20090210.trn' 
WITH RECOVERY