Today I restore a .bak file from my web host that contains my production data to my local SQL Server 2008.
Right click on “Databases –> Restore Database…” would bring up the following,
Since I don’t have an existing database to restore this .bak to, I put a new name “Personality.Prod”.
Choose “From device:” and locate the .bak file and check mark it and click OK.
The new .mdf and .ldf will be saved in your default database folder.