Forum Discussion
Solved
How to restore back SQL differential Backup in SQL 2016 management studio?
Hi Community,
Being a bit new to differential back up here. I have done Full Back up restoration before, but not so sure about differential ones.
May I ask to steps to restore back SQL differential Backup in SQL 2016 management studio?
Thank you!
joshlabtech , do a right-mouse click on the database in mind => Tasks => Restore => Database, the tools suggest the latest backups in right order.
Otherwise:
- Latest full back
+ Latest differential backup
+ All log backups since latest diff backup
1 Reply
joshlabtech , do a right-mouse click on the database in mind => Tasks => Restore => Database, the tools suggest the latest backups in right order.
Otherwise:
- Latest full back
+ Latest differential backup
+ All log backups since latest diff backup