how do I open a sql backup file .BAK

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: May 2008
Posts: 34
Reputation: ricksvoid is an unknown quantity at this point 
Solved Threads: 0
ricksvoid ricksvoid is offline Offline
Light Poster

how do I open a sql backup file .BAK

 
0
  #1
Feb 2nd, 2009
I have a large backup database file and I am having trouble opening it. I tried renaming it from database.BAK to database.MDF. I hope that this did not permanently destroy my hopes of ever recovering the database by changing the format.

Does anyone out there know how I can open this file and ultimatly convert it to a sql script so that i can deploy it to a remote server.


Thanks,
-Rick Pace
Reply With Quote Quick reply to this message  
Join Date: Dec 2008
Posts: 104
Reputation: Aneesh_Argent is an unknown quantity at this point 
Solved Threads: 18
Aneesh_Argent Aneesh_Argent is offline Offline
Junior Poster

Re: how do I open a sql backup file .BAK

 
0
  #2
Feb 3rd, 2009
Which DB are you using?
On MS Sql Studio Management Express, Right Click on the node "Databases" and Select "Restore Database" option.
Reply With Quote Quick reply to this message  
Join Date: Dec 2007
Posts: 1
Reputation: Islam Khalil is an unknown quantity at this point 
Solved Threads: 0
Islam Khalil Islam Khalil is offline Offline
Newbie Poster

Re: how do I open a sql backup file .BAK

 
0
  #3
Feb 3rd, 2009
no that dosn't resolved the problem to him
as i have the same problem with restoring the backup file in to my sql server and put in your considertaion that iam using enterprise edition

regads
Reply With Quote Quick reply to this message  
Join Date: Dec 2007
Posts: 252
Reputation: ProfessorPC is an unknown quantity at this point 
Solved Threads: 27
ProfessorPC ProfessorPC is offline Offline
Posting Whiz in Training

Re: how do I open a sql backup file .BAK

 
0
  #4
Feb 4th, 2009
do you know the original name of the db that was backed up? if you create a new db with the same name it is possible you can restore the .bak file that way
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the ASP.NET Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC