A great article on how to restore a SQL server has just been published by Veeam take a look below.

Source:  http://www.veeam.com/blog/how-to-restore-a-sql-server-database.html