完整链示例
完整链示例
RESTORE DATABASE [AppDB] FROM DISK = N'D:\backup\AppDB-full.bak' WITH NORECOVERY;
RESTORE DATABASE [AppDB] FROM DISK = N'D:\backup\AppDB-diff.bak' WITH NORECOVERY;
RESTORE LOG [AppDB] FROM DISK = N'D:\backup\AppDB-log.trn'
WITH RECOVERY, STOPAT = N'2026-10-12T10:29:00';| NORECOVERY | 中间步骤保持还原态，等待后续备份链 |
|---|---|
| RECOVERY | 最后一步应用并开放数据库 |
| MOVE | 文件路径变化时用 WITH MOVE 重定向 |
中间步骤误写 WITH RECOVERY 会提前开放数据库并截断还原链，后续日志无法再应用。