[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
_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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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