SQL Server DBA Tutorial 79-How to Restore a Database from Differential Backup in SQL Server

In this video you will learn how to restore SQL Server database using differential backup, how to add full backup and differential backup to restore, error concerning restore of differential backup with no full backup, database is not restored to correct earlier state. Tail Log backup options and best practices, restoring Differential database using T-SQL Script.

Blog link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[ukd]

thx for the explanation. Simple, but still good to hear what it should look like from start to finish.

[WealthofWisdom]

is it possible to restore differential backup to a full backup restored from 2 days ago?

[GuillermoDev]

Thanks, the video was very useful for me

[richgouette]

omg, once I fixated on the phrase "Go Ahead"..I could hardly pay attention to the rest of the dialog...
:O
good video though, OCD fixations excepting...

[amg]

Hi, I have a differential backup and transaction log backup done daily. After these, I did a Fullbackup. If I want to restore the database, will the option ‘Restore With Recovery’ using only the Fullbackup, the right one to get the DB up and running?.

[kwakupopsy]

Hello there do I need to have the existing database already available before the restore ? Or do i just have to create the database with same name then I can attempt the restore with full and differential