backing up act database
Posted: Jul 11, 09, 17:48 techAdmin
Status: Site Admin
Joined: 26 Sep 2003
Location: East Coast, West Coast? I know it's one of them.
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 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
Back to top
All times are GMT - 8 Hours