Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT Files in use during Nero backup

New Member
Posts: 7
Country: New Zealand

ACT Files in use during Nero backup

I'm getting the following message each time I try to back up my files, including ACT, to a DVD - this is after a restart so SQL, Outlook and ACT (v11) are not running..

 

Any ideas anybody ?

 

Thanks

 

Steve

 

The process cannot access the file because it is being used by another process.

 C:\Documents and Settings\Steve\My Documents\ACT\ACT for Windows 10\Databases\Clients.ADF
 
 The process cannot access the file because it is being used by another process.

 C:\Documents and Settings\Steve\My Documents\ACT\ACT for Windows 10\Databases\Clients.ALF

Platinum Elite Contributor
Posts: 14,388
Country: Australia

Re: ACT Files in use during Nero backup

ACT! uses a SQL Server database... and the SQL engine locks the database when Windows starts.

 

Your best option is to use ACT! Backup to create a ZIP file and then use Ne5ro to backup that ZIP

New Member
Posts: 7
Country: New Zealand

Re: ACT Files in use during Nero backup

Thanks Mike - will give this a go..

Platinum Elite Contributor
Posts: 14,388
Country: Australia

Re: ACT Files in use during Nero backup

The other option is to have a file that stops the SQL services before the backup and restarts them after.

 

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