Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act! 2008 Backup .tmp file toobig to C drive

New Member
Posts: 2
Country: USA

Act! 2008 Backup .tmp file toobig to C drive

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!

Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: Act! 2008 Backup .tmp file toobig to C drive

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.

New Member
Posts: 2
Country: USA

Re: Act! 2008 Backup .tmp file toobig to C drive

Is there any way to backup the ACT! datbase using the SQL backup rather than the ACT! backup? and if so, how?

 

Thanks

Platinum Elite Contributor
Posts: 14,387
Country: Australia

Re: Act! 2008 Backup .tmp file toobig to C drive

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 ACTSourceFolder="C:\Act\Database"
SET ACTDestinationFolder="D:\Backups\Act\Database"
SET XcopyOptions=/M /E /C /H /O /Y /I
REM
REM - Stop ACT Service
NET STOP SQLAGENT$ACT7
NET STOP MSSQL$ACT7
REM
REM - Perform copy
XCOPY %ACTSourceFolder% %ACTDestinationFolder% %XcopyOptions%
REM
REM - Restart ACT Service
NET START MSSQL$ACT7
NET START SQLAGENT$ACT7
END

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