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

Which DB are you using?
On MS Sql Studio Management Express, Right Click on the node "Databases" and Select "Restore Database" option.

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.