ASP.NET

ASP.NET RSS

how do I open a sql backup file .BAK

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

•

Join Date: May 2008

Posts: 34

Reputation: ricksvoid is an unknown quantity at this point

Solved Threads: 0

ricksvoid

Offline

Light Poster

how do I open a sql backup file .BAK

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

•

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

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.

•

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

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

•

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

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