05-13-2010 03:18 AM
I use a sync utility that backs all changed files on my system to a backup storage device. However, due to some issue with Act and SQL, it will not sync some of the Act files for my database. Any suggestions?
I do also backup Act within Act and copy/sync that file but I also like to just sync unzipped files as well.
Thanks in advance for your time and consideration.
05-14-2010 01:47 PM
Your Act! database files (ALF and ADF) are locked by the SQL program. As a general statement, you will not be able to copy them. The File > Backup > Database option is the recommended way to backup your data.
The only way to 'copy' the database files is to stop the service 'SQL Server (Act7)'. With this service stopped, SQL releases it's lock on the files. Should you decide to attempt this, you will need to ensure that no one is in the database when the service is stopped as it will break the connection to the database and can cause loss of any unsaved data.
05-14-2010 02:42 PM
06-03-2010 09:19 AM
06-03-2010 06:15 PM