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 differ...
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
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