Community
Showing results for 
Search instead for 
Do you mean 
Reply

Nightly back-up of shared databases

New Member
Posts: 3
Country: United States

Nightly back-up of shared databases

I'm curious to know if there is a way to reliably and automatically clear all the user logins or detach from the SQL instance to "unlock" the .alf and .adf files of shared ACT databases so I can perform a nightly off-site back-up?

 

It seems hit or miss when the databases allow them to be copied to the back-up and I'm not sure if this is due to the SQL service or remote users not properly logging out of the databases.

 

Any help would be greatly appreciated.

 

Thanks

 

-Chris

Platinum Elite Contributor
Posts: 14,384
Country: Australia
Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Nightly back-up of shared databases

Check to see if you backup program has the ability to backup open files. The one I use, Genie Backup Manager Pro, does and will backup the ADF and ALF files whether the SQL server is started or stopped.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 3
Country: United States

Re: Nightly back-up of shared databases

Thank you both!

 

-Chris

New Member
Posts: 3
Country: United States

Re: Nightly back-up of shared databases

Roy,

 

One last question. Do you know if Genie Backup Manager Pro will back-up the non-premium version (just the basic) version of ACT? Thanks.

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Nightly back-up of shared databases

I use it to backup my system data files which includes my emails and the ACT! database files. I use it for local backup but they also have an internet based services for off-site backup.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129