09-09-2011 03:33 PM
I continue to get an error message when trying to perform a database backup or copy the database to a backup drive. Any suggestions would be MUCH appreciated. Thanks
09-09-2011 06:50 PM
Are you using the ACT backup command (or via the scheduler)? You *cannot* just copy an ACT! database using either Copy from the operating system, or any 3rd party backup program. Since SQL Server "controls" the database, it's locked.
Here's instructions on how to properly backup:
Now, if you are doing the proper backup, and are receiving an error, please let us know what that is...
09-09-2011 08:37 PM
Hi Richard - I am using the ACT backup Command manually - the scheduler function is disabled. I have read through a number of post on this community forum looking for a solution. When attempting to do a backup using the backup command, I get an error message telling me the backup was terminated due to lack of space on my hard drive. Given that there is 118 gigs of free space remaining tells me there is something else going on.
I have Admin rights to the software, but not to this computer (company issue). I read one post mentioning that I need to disable the antivirus program - this is something my IT folks will need to address if you believe this may be the cause. I have also did a "save as" with a new name and tried to do a backup on that database without success. This issue is also preventing me from doing a standard backup up of my hard drive onto a backup hard drive.
Any suggestions or direction is much appreciated.
09-14-2011 06:07 AM
Can you verify that the space available is on the 'C:' drive? Even if you are directing the backup file to a different drive (ex: D), it will need to create a temporary file on the C: drive before creating the actual .zip file.