Restore my production SQL Server database

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,

Restore database

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.