January 26th, 2013, 05:44 PM
SQL .bak file problem
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.