27,579
社区成员
发帖
与我相关
我的任务
分享MSSQL 数据库恢复时的问题
我是用 SQL 语句进行差异备份的，
恢复时提示：
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.
恢复时提示：
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.
...全文
请发表友善的回复…
发表回复
zjpjzdz 2003-08-28
- 打赏
- 举报
要按时间先后，依次恢复吗？用 SQL 管理器恢复的话，是否会自动加 WITH NORECOVERY ?
zarge 2003-08-27
- 打赏
- 举报
先用之前的一次全备份来恢复，然后依次使用差异备份恢复，
除了最后一次恢复之外，都要加上WITH NORECOVERY
除了最后一次恢复之外，都要加上WITH NORECOVERY
zjpjzdz 2003-08-26
- 打赏
- 举报
老样子
hjb111 2003-08-26
- 打赏
- 举报
use master
go
RESTORE DATABASE TestDB FROM DISK = 'c:\yourdat.dat' WITH NORECOVERY
go
RESTORE DATABASE TestDB FROM DISK = 'c:\yourdat.dat' WITH NORECOVERY
zjpjzdz 2003-08-26
- 打赏
- 举报
还是这个错误！:(
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.
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.
pengdali 2003-08-26
- 打赏
- 举报
use master
RESTORE DATABASE TestDB FROM DISK = 'c:\2002.dat' WITH NORECOVERY
RESTORE DATABASE TestDB FROM DISK = 'c:\2002.dat' WITH NORECOVERY
