Error: The log or differential backup cannot be restored because no files are ready to rollforwar (4314094)

You may encounter the following error when attempting to restore a tlog backup to a database:

The log or differential backup cannot be restored because no files are ready to rollforward.

When the database was restore from a full backup the WITH NORECOVERY option was not used.

When you restore multiple files for the same database you should use the WITH NORECOVERY option (or select NORECOVERY from the GUI) for all the files
except the last one. You should specify WITH RECOVERY, the default, only on the last file of your recovery process.

Once you specify WITH RECOVERY you can not apply additional files to the restore procedure.

Example using the WITH NORECOVERY option :

exec master.dbo.xp_restore_database @database = Nnorthwind ,
@filename = ND:Backupdestination orthwind_full.bak,
@filenumber = 1,
@with = NSTATS = 10,
@with = NNORECOVERY,
@affinity = 0,
@logging = 0

GO

exec master.dbo.xp_restore_log @database = Nnorthwind ,
@filename = ND:Backupdestination orthwind_tlog.bak,
@filenumber = 1,
@with = NSTATS = 10,
@with = NRECOVERY,
@affinity = 0,
@logging = 0

GO

For additional information, see: SOL47161