Community
Showing results for 
Search instead for 
Do you mean 
Reply

What files to backup?

SMC
Copper Contributor
Posts: 16
Country: USA

What files to backup?

I am using Act 2008 and the Act email client.  What files or folders do I need to backup if I'm using a backup program instead of Act's built in backup function?
Steve Collins
IQ Accounting Solutions LLC
Peachtree Certified Consultant
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: What files to backup?

Most backup programs can't backup the database properly... best to use ACT!'s backup and have your backup program backup the ZIP it creates.

 

If not an option, you need to stop and then restart the SQL services. Something like this:

 

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