I have seen people struggling to restore differential back up. People tend to treat differential backup same as full backup. Restoring differential backup is simple with some minor differences in the way it is done for full backup.
the steps you need to follow are
1. Identify the diff backup that you need to restore.
2. Restore the latest full backup taken before the differential backup. follow the normal procedure as you always do. Select the backup file , Specify the database name , specify the location where the .mdf and .ldf files need to be placed.
3. Check the option “RESTORE WITH NORECOVERY” for recovery state. click OK.
now refresh the databases folder in your server. You can see the restored database in the norecovery mode. It will not be accessible.
4. Restore the differential backup with the same options as selected for full backup( ofcourse different .bak file ), but change the recovery state option to “RESTORE WITH RECOVERY” . click OK.
Now your database is completely restored and ready for use.
Please use the content at your own risk. In no event shall the
authors be liable for any claim, damages/issues that may be caused
by using the content.
Awesome SQL 
Hi my family member! I wish to say that this post is amazing, great written and come with approximately all vital infos.
I’d like to see more posts like this .
Thanks for some other magnificent post. Where ele could anyone
geet that type of info in such a perfect method of writing?
I’ve a presentation next week, and I am at the search for such info.