0

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, docs.microsoft.com/en-us/sql/t-sql/statements/… – tpet Aug 3 '18 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.) – Aaron Bertrand Aug 3 '18 at 20:52
  • Yes, the order is the same. But the thing is I am studying not in a disaster. – igelr Aug 4 '18 at 6:26
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, privacy policy and cookie policy

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