Recover ACT!

ACT! 2011 installed on computer #1.  Computer #1 crashed, but we have a backup of the filesystem.  Can we recover the ACT! database from the filesystem backup onto a new computer that we install ACT! onto?
LVL 1
Digital_SkreamAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

CompProbSolvCommented:
What sort of file system backup do you have?  Act! uses a database engine that tends to lock the file and some backups will not get the appropriate files.

In any case, I'd give the restoration a try.  It should not take too long and if you are doing this on a different computer you should not have anything to lose.
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
There will be a few things you need to do manually if:
1. You don't have the backup as a proper ACT! backup
2. The computer has a different "machine name" from the original

At very least, you'll need the database ADF file... preferably also the ALF file and the subfolder "DatabaseFiles"

If you confirm which of those is available, I can give you the next steps
Digital_SkreamAuthor Commented:
The ACT! installation was running on a Windows Server 2008 R2.  The clients would hten access it from their workstations, using .PAD files.  The server is backed up nightly via Windows Server backup using VSS.

i have the company .ADF, .ALF files, as well as the database files folder.
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Mike LazarusAct! Evangelist - CRM ConsultantCommented:
VSS does always correctly backup ACT! files ... if you get it up and running, you should use the ACT! Scheduler to run a backup to a ZIP file just prior to the VSS backup. That way, you'll have a correct backup should you need it in the future.

OK ... that being said:
1. Copy all the files (except the PAD file) to the appropriate data folder on the new machine
2. Open ACT! (assuming you have installed the same version and patched to the latest updates)
3. File | Open
4. Change type to ADF
5. Open the database ... this should check the file and create a new PAD file

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
Digital_SkreamAuthor Commented:
This solution worked perfectly!  thanks so much!
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
BTW: I meant to say "VSS does NOT always correctly backup ACT! files".... so, please set up the ACT! Scheduler to create the ZIP before the VSS runs
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.