4

I am wondering if this possible, I can not seem to apply another transaction log.

I have restored the Full database backup, the differential backup and my last Transaction Log WITH RECOVERY. If later on I need to apply the next Transaction Log in sequence to it, what do I need to do?

I tried applying the Transaction Log and it states:

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

For each time I need to add a new Transaction Log, do I have to go through the steps of restoring the backup database, restoring the differential database and all transaction logs again?

Improve this question
1
  • @Lennart the error message is SQL Server – Tom V Jun 29 '16 at 11:39
4

You have to start over and restore full and diffs with no recovery and then the tlogs with stand by option. This will allow you to restore tlogs later as well.

You can configure logshipping with option of stand by, so you can read from the secondary database.

There will be a .tuf (transaction undo file) file created when you restore tlogs with standby option.

For manually restoring tlogs use restore gene or you can just use logshipping for automated restores.

Improve this answer
0

Yes, if you want to apply additional transaction logs you will need to start back at your full backup. To quote MSDN,

The database cannot be recovered until after the final transaction log has been applied. If you recover the database after restoring one of the intermediate transaction log backups, that before the end of the log chain, you cannot restore the database past that point without restarting the complete restore sequence, starting with the full database backup.

https://msdn.microsoft.com/en-us/library/ms189596.aspx

Improve this answer
6
  • OMG, thanks for the answer..... This will be a major pain because I have over 400 Transaction Log files and more every day. When I really only need to add any new Transaction Logs (this is a read only database so the only new data is whatever I load from the NEW Transaction Logs). – image13 Jun 28 '16 at 19:51
  • You can script the restore which will make those 400 files a bit more manageable. Try something like mssqltips.com/sqlservertip/1584/… or sqlservercentral.com/articles/Restore/95839 – tpet Jun 28 '16 at 19:53
  • Is this not a candidate for log shipping? – rvsc48 Jun 28 '16 at 20:20
  • Yea, I think that would do it.. I never knew that was what it was called. Hmmm will just have to research on how to do it. Thanks Rob! – image13 Jun 28 '16 at 22:54
  • Would I be able to use their Full Database Backup to start this process? – image13 Jun 28 '16 at 23:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.