how to open sql.bak file in SQL Studio managment express

I download a back database file 8GB to my XP local computer and i am trying to open it with SQL Stuido managment express

i added .mdf to the file name and i double click on the file and choose to open it with SSME and vizard installation of SQL Server 2005 started and finish ok without errors or warnning but at the end a meassge show that file can not be open (see attachment)

what i am doing wrong? or how i can open the .bak file

Thanks
Gvilbis
open-sql-db.JPG
gvilbisAsked:
Who is Participating?
 
David ToddConnect With a Mentor Senior DBACommented:
Hi,

>>You must create a new database with the same name.

Wrong, the restored database can be called - within reason - anythingyoulike!

If the database is from another SQL instance, from memory you need to specify with replace.

If the database is restored to something other than original database you need to specify with replace.

If specifying with replace, need to specify the mapping between logical filenames and physical filenames.

Its a good practice to always specify the mapping between logical filenames and physical filenames and not just accept the default location/filename.

HTH
  David
0
 
EddyvanOpdorpConnect With a Mentor Commented:
Hi,

You must create a new database with the same name.
Choos restore for that database, and restore from disk. Selecte the .bak file.

See here:
http://msdn.microsoft.com/en-us/library/ms177429.aspx
0
 
Matt BowlerConnect With a Mentor DB team leadCommented:
Yep - this looks like a backup file and will need to be restored to a SQL Server instance - nothing useful can be gained from 'opening' this file...

Do you have SSME installed on the machine you are working on? How about SQL Server?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Anthony PerkinsConnect With a Mentor Commented:
This is a duplicate question and should be deleted, please see here:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_28139818.html
0
 
Anthony PerkinsCommented:
Mind boggling.
0
 
David ToddSenior DBACommented:
Hi Antony

>> Mind boggling
Yip, only got a grade of B for that solution. I thought it deserved at least an A <wry grin>

Regards
  David
0
 
Anthony PerkinsCommented:
Yes, not to mention that my non-solution was "awarded" points which sort of defeats the point of this site.  Rather sad considering the author has been a member for nearly 3 years.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.