10-16-2014 09:08 PM
I'm trying to backup my database so I can move it to another local computer. When I initiate backup (File, Backup, Databases) I get the following error, "Sage ACT! The following error occurred during backup. The backup was cancelled. Incorrect syntax near '2013'. PRC_MAINT_BACKUPDB: ERROR EXECUTING DATABASE BACKUP STATEMENT"
General Information: Windows 7 Pro, SP1
Sage ACT! Pro 2011 Version 18.104.22.168, Hotfix 1
Backup file location: C:\Users\Assistant\Documents\ACT\ACT Data\Backup\ACT! 2013CustomerDb.zip
I have tried renaming the zip file but that doesn't solve the issue.