Community
Showing results for 
Search instead for 
Do you mean 
Reply

auto backup

Avid Listener
Posts: 49
Country: aus

auto backup

hi
 
just wondering if its possible to backup act version 9.0.1.162
 
with automatic backup softwares
 
with out accessing the sql
 
and
 
is it possible to undo a delete contact if a contact is deleted by mistake
 
thanks in advance
 
 
Nickel Elite Contributor
Posts: 595
Country: USA

Re: auto backup

Sorry, no to both questions.
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com
Nickel Super Contributor
Posts: 441
Country: UK

Re: auto backup

Depens what you mean by without accessing SQL.  If you mean without using the sa password then Yes, you can schedule the SQL service to stop, back up the db and schedule it to start again or you could try something like our schedule product accessible here(http://www.rowcol.co.uk/acatalog/AddOns.html).  Of course if you have the ACT! Workgroups product you will have the ACT! scheduler.
 
Tom
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: auto backup

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
Nickel Super Contributor
Posts: 441
Country: UK

Re: auto backup



GLComputing wrote:
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



In v9 the service name is different.  I would edit the text above to read:
 
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
REM--------EDITED TEXT BELOW-----------
NET STOP "Sql Server (Act7)"
REM--------END EDITED TEXT-----------
REM
REM - Perform copy
XCOPY %ACTSourceFolder% %ACTDestinationFolder% %XcopyOptions%
REM
REM - Restart ACT Service
REM--------EDITED TEXT BELOW-----------
NET START "Sql Server (Act7)"
REM--------END EDITED TEXT-----------
END
 
 
Tom
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: auto backup