How to RESTORE A DATABASE FROM DIFFERENTIAL BACKUP in SQL Server

Differential Backups are used to back up data that has changed since the last full backup.

For example, if I took a full back up on Yesterday, then Today I could take a differential back up, and the only thing backed up would be any data that has changed between Yesterday and Today.

Differential backup is quicker than full back up; however, the restoration process is slower than the latter.

Watch my videos on

How to Manually Backup Databases in SQL Server Management Studio

Create Maintenance Plan to Back up Database in SQL Server 2016

How to Restore a Database Backup File (.BAK) in SQL Server 2016

[biwithmina]

Dear Subscribers,
Thank you for your interest in our videos.
We value all of your feedback and will do our best to reply in the comments.
Nevertheless, we may not be able to answer all practical questions, via comments.
To help with practical sessions, our dedicated team can be reached through email.

[xCONNORx]

I appreciate your video as it allowed me to quickly understand the basic concept of restoring a SQL DB using a full backup and differential backup. Thanks!

edit: I did it a little differently as I was able to select both the differential and the full backup and SSMS merged them together without having to select "restore with nonrecovery".

[razordialer]

Thanks, that's a good guide, it has saved my time

[abolfazlsafarpoor]

Thank you for explaining this, i was doing something wrong and i got an error that says something about roll forwarding

[TylerMoore-wvju]

Is there a way to take a database out of RECOVERY to restore an additional differential database later? Or do you need to start from the main database every time. Thanks for the video.

[RichardHema]

Thank you, very helpful and appreciated.

[danieltlanepantlapantoja]

Your video was helpful for me! Thank you

[jeffersonsobreira]

Thank you, thank you, thank you and thank you!!! You just saved a soul!! ;)

[WealthofWisdom]

I have recently restored full backup to a new server. After 3 days, the user requested me to create differential backup from the old server and wants me to restore to new server on the recent restored full backup... is this possible?

[biwithmina]

Please SUBSCRIBE, SHARE, COMMENT, AND LIKE MY VIDEOS