• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 583
  • Last Modified:

How to recover .BAK files?

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?
0
tphelps19
Asked:
tphelps19
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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 ...
0
 
chapmandewCommented:
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'
0
 
tphelps19IT ManagerAuthor 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!
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
_Commented:
Try Recuva. If they haven't been overwritten you might be able to undelete the last ones.
http://www.recuva.com/
0
 
tphelps19IT ManagerAuthor Commented:
I didn't recover my files, but this was the best tool out of all of them.  Thanks.
0
 
_Commented:
Thank you much.    
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now