Community
Showing results for 
Search instead for 
Do you mean 
Reply

Copy my database...

New Member
Posts: 1
Country: USA

Copy my database...

One of my clients does a nightly Xcopy backup to an external hard drive for all their files. The Act! database files do not copy over, they report that they are in use, even if all users are logged out. There are a couple of backup files (.zip files) in one of the sub directories. These also do not copy...

 

Is what I'm looking to accomplish possible?

Nickel Elite Contributor
Posts: 595
Country: USA

Re: Copy my database...

Not the way you are trying to do it. The database files are attached to the SQL server and are held open by the server. Your choices are to stop the SQL server prior to doing the copy, use the backup in ACT! to create a zip file which can be copied or use a backup program like Genie Backup Manager Pro V8.0 which has open file backup capabilities.
Roy Laudenslager
ACT! Certified Consultant
Techbenders
royel@techbenders.com
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Copy my database...

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