06-18-2008 11:27 AM
We are using Act! 2008 and the automatic backup creates a temporary (.tmp) file while backing up. This file is too big for our C drive. How can this be redirected to the D drive. I tried changing the Environmental Variables for >tmp but it did not work for this file.
Thanks in advance for your help!
06-18-2008 12:38 PM
It's created in the Database Supplemental Files Backup folder... you can't change this.
If the Backup crashes, it leaves the tmp files there and they get included in subsequent backups.
Go to the Backup folder under the Database folder and delete any files there. Also, delete any files in c:\Windows\Temp and in %temp%
Try a backup again.
See if that helps.
06-28-2008 06:10 AM
Yes, you need the SA Pass utility from http://www.act.com/products/large/cl/services/index.cfm/
Or you can stop the SQL services, backup the files normally and then restart the services. Something like:
Create an ACT10Backup.bat file in Notepad as follows:
REM - Change the SET Paramaters as appropriate for your system
SET XcopyOptions=/M /E /C /H /O /Y /I
REM - Stop ACT Service
NET STOP SQLAGENT$ACT7
NET STOP MSSQL$ACT7
REM - Perform copy
XCOPY %ACTSourceFolder% %ACTDestinationFolder% %XcopyOptions%
REM - Restart ACT Service
NET START MSSQL$ACT7
NET START SQLAGENT$ACT7
With the SQL engine stopped, you can use anything to copy/backup the database and supplemental files. You could replace the XCOPY with a command line ZIP or other back-up utility.
Then run the BAT file from the Windows scheduler... or, if your backup program permits, include the SQL stop lines before the backup and the start lines after the backup