I have the full backup of a database, also one differential backup and one log backup. Is it possible to restore this 3 backups together? SSMS lets only full backup and only one of them. Is there a way to restore both? It's okay to show the way in t-sql too.

Thanks for your time!

  • 2
    Try looking here for restores with NORECOVERY, learn.microsoft.com/en-us/sql/t-sql/statements/…
    – tpet
    Commented Aug 3, 2018 at 20:26
  • 1
    Are you sure the log backup was taken after the diff, and that the diff is based on that specific full backup? (I only ask because in a disaster people will scramble to find these things on archives or wherever and they sometimes don't have anything to do with each other.) Commented Aug 3, 2018 at 20:52
  • Yes, the order is the same. But the thing is I am studying not in a disaster.
    – igelr
    Commented Aug 4, 2018 at 6:26

1 Answer 1


Use tsql. Also, highly recommend to use sp_restoregene. This will generate restore commands for you which you can just execute .

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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