Community
Showing results for 
Search instead for 
Do you mean 
Reply

Backup Recovery

Accepted Solution Solved
New Member
Posts: 4
Country: USA
Accepted Solution

Backup Recovery

I hope this is appropriate for this community

I recently discovered that I had some important entries that I no longer can replicate.  I have a backup from just before the entries, which does not help.  I also have a drive backup from after those entries, and need help in getting the information back into an active ACT database.  I copied the file MSSQL$ACT7 into the SQL server directory, and the database files into an ACT directory under users>public.  Is there another file (perhaps a config file) that I should copy in, as I can not get ACT to see the database.  Oh, and this is a fresh harddrive, so no other databases to interfere with.

Thanks


Accepted Solutions
Solution
Accepted by topic author rldavey
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Backup Recovery

That is the ACT! instance of the SQL server, it doesn't include the database files. The best is to use the backup in the ACT! program (you can schedule the backups) and then the system backup can backup the backup file.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Backup Recovery

Did the ACT! database files include the ADF and ALF files? If so try deleting the PAD file and open the ADF file.

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

Re: Backup Recovery

The ADF and ALF files are not there.  Thanks for answering!

 

Robert Davey

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Backup Recovery

The ADF and ALF are the actual database files and because the SQL server opens them at boot time they typically not backed up by a drive backup.

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

Re: Backup Recovery

[ Edited ]

What is the function of the MSSQL$ACT7 file then?  I think I have another backup with NovaBack (a system backup).  Hopefully I can get the files from there.

 

Thanks again.

Robert Davey

Solution
Accepted by topic author rldavey
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Backup Recovery

That is the ACT! instance of the SQL server, it doesn't include the database files. The best is to use the backup in the ACT! program (you can schedule the backups) and then the system backup can backup the backup file.

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

Re: Backup Recovery

Thanks so much.  I have been using the backup, unfortunately in this instance it was not enough. 

 

Robert Davey