When I want to restore a Microsoft SQL Server database, I take the following steps:

• Copy the *.bak file to a local folder on the databaserver, like [C:\Temp]
• Open Microsoft SQL Server Management Studio and connect to the Microsoft SQL Server Instance, you want the database restored to
• Kill all processes that are connecting to the database, you want to restore. In the Object Explorer:
• Expand [Management]
• Right click [Activity Monitor]
• Click [View Processes]
• Right click a process
• Click [Kill Process]
• To restore the backup (*.bak) file, in the Object Explorer:
• Right click [Databases]
• Click [Restore Database…]
• Select the database, you whish to restore or type in a new database name
• Click [From device]
• Click [Add]
• Select you’re database file and click [OK]
• Check the column [Restore]
• Click [Options]
• Check Overwrite the existing database
• Change the [Restore As] locations
• Right click Databases > Restore Database

Screendumps