Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT! Premium 2009 - Disaster Recovery

Accepted Solution Solved
New Member
Posts: 4
Country: United States
Accepted Solution

ACT! Premium 2009 - Disaster Recovery

I was wondering what options are available to me for the disaster recovery of ACT! Premium 2009 with a minimal recovery point objective. From my understanding the ACT! DB can not be backed up live which would lead to an undesirable RPO. Does anyone know of or has implemented a solution that will allow for offsite replication with a minimal RPO? Thank you in advance for your time.

Accepted Solutions
Solution
Accepted by topic author pcolvin
‎09-25-2015 03:20 AM
Silver Elite Contributor
Posts: 3,336
Country: United_Kingdom

Re: ACT! Premium 2009 - Disaster Recovery

I always recommend using the ACT! scheduler utility to create regular backups from within the ACT! program. When ACT! makes its own backup it creates a zip file containing everything needed to restore your database if required (File > Restore > Database). ACT! backups can be created with ACT! running, and you can decide where the zip file goes on your server. If you use the ACT! scheduler, you can also specify how many backups to retain on your system (each file is appended with date and time).

 

Your regular server backup will then have no problem backing up the ACT! backup zip file, so you have a belt-and-braces solution.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk

View solution in original post


All Replies
Solution
Accepted by topic author pcolvin
‎09-25-2015 03:20 AM
Silver Elite Contributor
Posts: 3,336
Country: United_Kingdom

Re: ACT! Premium 2009 - Disaster Recovery

I always recommend using the ACT! scheduler utility to create regular backups from within the ACT! program. When ACT! makes its own backup it creates a zip file containing everything needed to restore your database if required (File > Restore > Database). ACT! backups can be created with ACT! running, and you can decide where the zip file goes on your server. If you use the ACT! scheduler, you can also specify how many backups to retain on your system (each file is appended with date and time).

 

Your regular server backup will then have no problem backing up the ACT! backup zip file, so you have a belt-and-braces solution.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT! Premium 2009 - Disaster Recovery

New Member
Posts: 4
Country: United States

Re: ACT! Premium 2009 - Disaster Recovery

Jeff,

 

Thank you very much for your input. According to our ACT! consultant the ACT! DB cannot be backed up live. I guess it may be time for a new ACT! consultant.

 

PC

New Member
Posts: 4
Country: United States

Re: ACT! Premium 2009 - Disaster Recovery

Thanks for the link Mike!
Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: ACT! Premium 2009 - Disaster Recovery

Actually there are backup programs that will backup open files. The one I use is Genie Backup Manager Pro V8 from Genie Soft. I use it to backup my ACT! databases and I have tested the reliably of the backup and I could bring the files back from the backup drive and reconnect the ACT! database to MSSQL and it opened fine.
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: United States

Re: ACT! Premium 2009 - Disaster Recovery

I wanted to correct myself...my ACT! Consultant did not say it would not backup during the day, she recommended against it because of the performance hit during the backup time frame.
Silver Elite Contributor
Posts: 3,336
Country: United_Kingdom

Re: ACT! Premium 2009 - Disaster Recovery

The usual issue, as Roy referred to above, is that some backup software cannot back up open files, and the SQL files used by ACT! are always open, even if ACT! itself is not runnning, so you need to check the capabilities of your backup software.

 

I always go for the ACT! backup partly because it creates a ZIP file that can be backed up itself if required by any generic backup solution.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk