How do you find find out what is inside a BAK file?

I'm trying to find a file that I last used 2 years ago.  I think it may be in a .BAK file.  How do you find the contents?
RandytcodeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Based on that you posted to the ACT! Zone, I assume you're looking for ACT! data?
There shouldn't be a BAK file - these are temp files when creating a backup
ACT! backup files should be a ZIP file
What version of ACT!?
What files have you found? In what folders?
0
RandytcodeAuthor Commented:
I found reports, layouts etc but in the folder labled "database" there are 3 BAK files.  Can you access temp files?
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Can you find an ADF file?

Which version of ACT!?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

RandytcodeAuthor Commented:
Currently on ACT 8. Just installed.  Where should I look for the ADF file?
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
In the database folder

You might try using Windows to search the drive

what version is the backup supposedly from?
0
RandytcodeAuthor Commented:
Don't know if it's ACT 2000 or later.  The files have a date of 2005 on them.  I've had several versions throughout the years.  I've tried to use the program off and on but never got myself to commit to maintaining the detail like I should.  So here I am trying again with a new version but needing this old data.  I looked through old hardrives but can't find a zip file that would have been the sister file to these BAK files.  As you have probably guessed, it means a lot to me.
0
RandytcodeAuthor Commented:
I was wrong about the "date of 2005 on them".  It's 2006.  Still don't know exactly which version.  I will look for the zip again.  There's no way to get what seems to be in a "temp" file out?
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
If it's ACT! 2000 (5.0) or 6.0, see if you can find a DBF file on your computer

ACT! 2005 (7.0) was released in 2005 - and 7.0 and later had very different files to 5/6, which is why the version would help in this. ACT! 8.0

BTW: Where are you based? Depending on your location, it might be worth while have an ACC have a look over your system.

It may be possible to get a temp file restored (depending on the file and what stage it was created), but knowing the version would make it easier

Do you know how to do a search of the HDD in Windows?
Start | Search

Look for DBF for 6.0 and earlier or ADF for 7.0 and later
0
RandytcodeAuthor Commented:
I've searched for dbf and ADF and can't find them.  I have looked on old hardrives also.  I've also asked the folks with ACT to call me with a support plan but I'm not giving up here.  I'm currious to see if someone can find a solution for this.

The BAK files must be accessable in some way.  Even if I got strings of information to mend together, I'd be better off.  The BAK file is about 50MB I think.  There has to be some way to look into its content?????  How would the CSI guys do it?
0
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Where are you located? I might be able to recommend someone with some skills to have a look
0
Anthony PerkinsCommented:
More than likely it is a SQL Server backup file.  You can tell by opening it in a Hex editor:  The first few characters should be TAPE followed soon after by Microsoft SQL Server
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David ToddSenior DBACommented:
Hi,

If a SQL backup try
RESTORE HEADERONLY
FROM disk = 'path and filename'

RESTORE FILELISTONLY
FROM disk = 'path and filename'

HTH
  David
0
RandytcodeAuthor Commented:
I guess I hate to show my ignorance but I need to see this if I can.  Where do I type the suggestion above?
0
Anthony PerkinsCommented:
In order to execute any SQL Server command such as RESTORE you would need to have SQL Server installed and permissions to restore files.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ACT

From novice to tech pro — start learning today.