Community
Showing results for 
Search instead for 
Do you mean 
Reply

Can't find the database files after HD crash

Copper Contributor
Posts: 8
Country: USA

Can't find the database files after HD crash

Hopefully someone can point me in the right direction....

 

I had a HD crash this last week - but backed up my entire drive only six weeks before. BUT, I can't find the correct database files.

 

The only files I can find are from 2013. I'm not sure if I'm looking for the wrong file extension, but I know the data is here, I just can't find it. Any help would be REALLY appreciated.

 

Thanks!

Copper Elite Contributor
Posts: 107
Country: United States

Re: Can't find the database files after HD crash

Your backup files will end in the .zip extension.  The database files will end in .adf and .alf; you'll also should see a set of database folders which will contain your layouts, templates, etc.  And make sure once you recover everything that you set the Act Scheduler to create automatic backups so this doesn't happen again in the future!

Karen Fredricks
Tech Benders
561-470-5450
Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Can't find the database files after HD crash

How did you backup your hard drive? Depending on how and where you did the backup to you may not have actually backed up your database files.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 8
Country: USA

Re: Can't find the database files after HD crash

I used the Seagate Backup Plus. I haven't had a chance to look for the other file extensions mentioned yet but am doing it now...

 

Why do you think it might not have backed it up?

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Can't find the database files after HD crash

Gecause most backup programs including web based ones won't backup open files. The SQL server loads a boot time and opens all attached database files. To be sure you have an ACT! database backup you need to backup the ACT! Database using the backup capability in the ACT! program. My guess is that you won't find the database files in the backup.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 8
Country: USA

Re: Can't find the database files after HD crash

So here is an update. I've found an older backup .zip file that dates to 2014.

 

My database was not open or running during the crash so it should still be intact....but I still cannot find it.

 

What is the default folder it's typically saved in?

 

My Act>Act for Windows 12> folder has:

 

Documents (empty)

Databases (demo only)

Backup (one zip file from 2014)

 

I must be missing something. Help!

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Can't find the database files after HD crash

Unless the SQL server was stopped, the database was open, even if ACT! was closed. Try searching the drive for the file extension ADF.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Administrator
Posts: 262
Country: USA

Re: Can't find the database files after HD crash

Hi cscamgrl99,

 

Just to expound on what Roy said, your database is made up of 3 files / folders.  An [database name].ADF file an [database name].ALF file and a folder named [your database name] – database files.  Searching the hard drive backup is unfortunately the only option if the files are not in the default location. 

 

Thank You,
Brittany Roberts

Brittany Roberts
Act! Digital Specialist