I am doing some private work for a client who sent me a .bak file which is a backup file from an sql database.

I have sql server management studio installed on my work laptop which when I am connected to my office automatically connects to a datawarehouse over a network.

I have the .bak file stored locally and dont think I have sql server management studio connected to a localhost.

I am struggling in opening this file and I need to eventually get the data into excel.

I am a novice using SQL and can do basic queries.

Please can someone help me with advising me on how I do restore the backup ito sql server management studio?

So, as an alternative I installed MS SQL Server Express 2005 on my home laptop and all I can see is configuration tools and not the programme to open up the sql..

Please help Thank you.