07-19-2015 10:35 AM
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.
07-19-2015 11:10 AM
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!
07-19-2015 11:54 AM
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.
07-19-2015 04:44 PM
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?
07-19-2015 09:26 PM
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.
07-29-2015 11:37 AM
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:
Databases (demo only)
Backup (one zip file from 2014)
I must be missing something. Help!
07-29-2015 01:29 PM
Unless the SQL server was stopped, the database was open, even if ACT! was closed. Try searching the drive for the file extension ADF.
07-30-2015 11:32 AM
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.