If we want to restore database with differential backup then first we need to restore associated fill backup with NORECOVERY option.
Below is example…
——————————————————————–
RESTORE DATABASE AdventureWorks FROM DISK = ‘C:\AdventureWorks.BAK’
WITH NORECOVERY
——————————————————————–
Only after that we can apply Differential backup on the database…
Below is the example…
——————————————————————–
RESTORE DATABASE AdventureWorks FROM DISK = ‘C:\AdventureWorks_Diff.BAK’
——————————————————————–
Leave a Reply