SQL Server差异备份还原

RESTORE DATABASE [DataBase] FROM  DISK = N'完整备份.bak' WITH  FILE = 1,  MOVE N'DataBase' TO N'新文件.mdf',  MOVE N'DataBase_log' TO N'新文件.ldf',  NORECOVERY,  NOUNLOAD,  STATS = 10
RESTORE DATABASE [DataBase] FROM  DISK = N'差异备份.bak' WITH  FILE = 1,  MOVE N'DataBase' TO N'新文件.mdf',  MOVE N'DataBase_log' TO N'新文件.ldf',  NORECOVERY,  NOUNLOAD,  STATS = 10
RESTORE DATABASE [DataBase] FROM  DISK = N'差异备份.bak' WITH  FILE = 1,  MOVE N'DataBase' TO N'新文件.mdf',  MOVE N'DataBase_log' TO N'新文件.ldf',  NORECOVERY,  NOUNLOAD,  STATS = 10
RESTORE DATABASE [DataBase] FROM  DISK = N'差异备份.bak' WITH  FILE = 1,  MOVE N'DataBase' TO N'新文件.mdf',  MOVE N'DataBase_log' TO N'新文件.ldf',  NOUNLOAD,  STATS = 10

容易弄错的是，前几个恢复都要加上"NORECOVERY"关键字，最后一个不要加