backing up act database

[techAdmin]

You need to stop the db first: community.act.com/sage/board/message?board.id=ACT&thread.id=13158

:: Quote ::

As Paul said, moving it manually is the only option - ACT! 2006 had a problem with backups of over 4GB



You'll also need to set up a process of backing up for future use. One such option is this...



Create an ACTBackup.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