04-14-2011 03:44 PM
Does anyone know what or how I can figure out the SQL SA password for ACT? I want to backup the live database file and need access via SQL Enterprise to add the appropriate windows server users. My version is ACT! by Sage Premium for Workgroups 2006 Version 18.104.22.168. Thanks!
04-14-2011 05:02 PM
04-14-2011 10:03 PM
Use the ACT! Scheduler to backup the ACT! database. Not only is it built-in, it creates a zip file that is then easily added to any backup program/schedule. Furthermore, if you do have a database issue, and need to restore a backup, restoring from the latest zip file is super-quick and easy vs. getting similar data from a detached SQL backup, or in your case, directly from SQL.
Hope this helps, they've made it as easy as possible to backup and restore if necessary, don't complicate it...