Running this SQL query:
RESTORE DATABASE Demo FROM DISK = 'C:\DBBackup\Demo_FULL_Sunday.bak' WITH NORECOVERY RESTORE DATABASE Demo FROM DISK = 'C:\DBBackup\Demo_Diff_Monday.bak' WITH RECOVERY
I'm getting these errors:
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.
I have also tried adding
WITH REPLACE but no luck. This is meant to restore to a report server, not to the original server that the backup was taken from.
I have tried Googling, however everything I read just says to make sure you are using