在还原完全后再进行差异还原出现:The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step. 此问题.应如何解决;
from disk= 'D:\Test\DB-DF03_full ' --恢复完全备份
with Recovery --必须用此选项restore database NewDB
from disk= 'D:\Test\DB-DF03 '
with NoRecovery恢复完全备份后,恢复差异备份时不能马上恢复,得先选择“read backup set information and add to backup history”完了再进去选择备份点才能够恢复备份成功。
比如
RESTORE DATABASE databasename FROM ... WITH NORECOVERY
Line 1: Incorrect syntax near '122'.
Cannot open backup device 'f:\122.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Server: Msg 3201, Level 16, State 2, Line 5
Cannot open backup device 'f:\2222.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 5
RESTORE DATABASE is terminating abnormally.