我不小心删除了表格中的一行并希望恢复它。我在这里找到了一个解决方案:如何从MS SQL服务器中恢复已删除的记录
我尝试从删除后备份的数据中恢复数据库。但我无法使用STOPAT选项还原数据库:
RESTORE LOG database FROM DISK = N'X:\database.BAK' WITH
STOPAT = N'2011-02-12T00:00:00', RECOVERY
我有以下错误:
Msg 3117, Level 16, State 4, Line 1
The log or differential backup cannot be restored because no files are
ready to rollforward.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.