12-27-2014 08:16 PM
I am posting as I have an issue regarding my ACT backup.
Below are the details:
ACT Version: ACT 2013 PRO Version 126.96.36.199
Database State: Shared over LAN
OS: Windows 8.1
Situation: I am trying to backup our company ACT database and receive the following error message:
"The following error occurred during backup. The backup was cancelled. The process canot access the file 'xx.tmp' because it is being used by another process"
Hence, the backup stops. This happens each and every time and I cannot backup the database.
Any guidance or assistance would be greatly appreciated.
12-28-2014 02:15 AM
This error message can occur if you are trying to backup your Act! database with Attachments while there is an attachment open.
12-28-2014 04:35 AM
Thanks for the reply.
But unfortunately, no, I am not backing up the database with attachments. I am just backing up the database with NO attachments.
As well, the database is locked and all other users have their ACT closed and their stations turned off. Hence, no one but me, on the host machine, is accessing the database.
Now, there is one interesting things that happens.
The size of the .adf is around 1.17GB. What seems to happen is that when the backup process stops it is because a .tmp file is being access by another user, which is not possible as there is no one else logged into the database or to the hosted machine. The .tmp file is located in the hosted machine's Windows Temp folder and the size of that file is 87GB.
So there are two bizarre things that happen;
1. That the .tmp file that is being created is being accessed by another user, which is not possible as no one else is logged on to the system and even if they were, they would not be accessing for .tmp file which is being created only during the backup process.
2. The size of the .tmp file is massive- approx. 87GB.
The .tmp file in question is being saved on the system drive C:, while the database is being hosted on a secondary drive on the hosted machine. I have moved the indicies to this secondary drive where the database is stored and hosted, as it has more space than the system C: drive.
Again, I am at a loss as I cannot backup the database, without doing a 'save as', and this issue has been going on for months. Our office is off over the Christmas & New Year break, which is why I am trying to solve this issue over the course of this week before everyone comes back.
Any help or assistance would be greatly appreciated.
Thank you in advance!
12-28-2014 06:56 AM
12-28-2014 05:26 PM
Thanks again for your advice and help.
Yes, it could be a disk space issue, although when the error pops up there is still over 90GB of disk space.
So I am not 100% certain that it is disk space as there is plenty of space remaining. But again there is something odd as the .tmp file that is being created is 87GB, which is massive in itself. Again, even with an 87 GB .tmp file that is created there is still over 90GB of space remaining.
If it is a disk space issue, other than replacing the drive with more space, I do have a secondary drive which hosts the database itself and have loads of space. Is there a way for the .tmp file and the SQL backup to write itself onto the secondary drive or any destination that I desire?
Thanks again for all your assistance.