Nightly back-up of shared databases

[metalav8b]

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

[GLComputing]

See this article:

http://blog.glcomputing.com.au/2009/09/automating-backups-for-act-by-sage.html

[Roy_Laudenslager]

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.

[metalav8b]

Thank you both!

-Chris

[metalav8b]

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.

[Roy_Laudenslager]

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.