Working with backup sets : Microsoft SQL Server database backup sets (Windows) : Restoring a Microsoft SQL Server database backup set
 
Restoring a Microsoft SQL Server database backup set
Only users with the required permissions can restore Microsoft SQL Servers. The procedure for this type of restore is provided below. Steps that are similar to or same as those for File system restores will only be briefly mentioned.
See important information on this type of restore in the Knowledge Base article in “Backup / restore of Microsoft SQL Server (all versions)”.