Perform a normal file restore of the MS-SQL backup set(s) to a temporary location – this will extract the SQL .BAK files ready to be loaded into SQL management studio.
Open SQL Server Management Studio.
Login to the database server using an appropriate administrator-level account
In the object explorer, right click on “Databases” and choose “Restore database…”
Choose the radio button to restore from a device, then click the “…” to pop open the “Select backup devices” dialog
Click Add to select the location of the restored backup files from the previous steps
Locate the .BAK backup file to restore from
Confirm that your selections are OK
Review your restore parameters before proceeding
In particular, on the options page you may want to overwrite the existing database
When satisfied, click OK to proceed with the restore back into SQL server
