We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How to recover .BAK files?

Medium Priority
605 Views
Last Modified: 2012-05-07
I'm in deep yogurt here.  My MS SQL server was set to keep 2 weeks of backups and we just recently had a big problem that requires us to restore, but somehow the amount of time to keep those files got reset to 2 days!  

The only recourse that I think I have is to do file recovery but I can't find a good file recovery program that supports .BAK files.  Apparently all the file recovery programs need to be programmed with certain file types in order to properly work.  Can someone help me out with what to use for SQL .BAK backup files?
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
you have to go 2 steps:
? file recovery of the .bak file (although I must admit that the risk that all your deleted .bak files have been at least partially overwritten is quite high on a database server)
? from the recovered .bak file, you restore the database with the BACKUP DATABASE yourdb FROM FILE='path with.bak' etc ...
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
So, do you have a recent full backup?  If so, you can restore the backup file very easily:

restore database newdbname  --give it a new name
from disk = 'C:\bakup.bak'  --path to backup file
with
move 'logical data file' to 'c:\datafile.mdf',
move 'logical log file' to 'c:\logfile.ldf'

you can get the logical names using this:

restore filelistonly from disk = 'c:\bakup.bak'
tphelps19IT Manager

Author

Commented:
Angelll:

That's exactly what I'm trying to do but I'm trying to find a recovery software package that is good at recovering .BAK files (or any files for that matter, but just a good recovery program)

Thanks!
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
tphelps19IT Manager

Author

Commented:
I didn't recover my files, but this was the best tool out of all of them.  Thanks.
_

Commented:
Thank you much.    
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.