backing up act database
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 Back to top |
All times are GMT - 8 Hours |