Error: Msg 3117 The log or differential backup cannot be restored because no files are ready to r
说明
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 DATABASE is terminating abnormally.
原因
Database is not in correct mode for a DIfferential or Transactin Log restore.
解决办法
A differential backup, though only containing changed data pages since the last full database backup, can only be restored in conjuntion with a full backup similar to using log backups. You dont have the ability to restore only single tables or objects, but you can restore at the database, filegroup, file, and page level. You can also restore up to a particular point in time from any of the backups (assuming youve restored the required preceding full, diff, logs).
WORKAROUND: Determine the database status from sys.databases SELECT recovery_model = (SELECT DATABASEPROPERTYEX(NNorthwind, NRECOVERY))