Hi,
I am receiving an error message during Backup ACT Pro 2012.
I have tried many times to solve this problem using different ways but failed.
I need your help to fix this issue.
Thanks.
Sage Act!
The following error occurred during backup. The back was canceled.
Incorrect syntax near ‘LapTop’. STATS=10, NOFORMAT.
PRC_MAJNT_BACKUPDB: ERROR EXECUTING DATABASE BACKUP
STATEMENT
OK
Sage ACT backup error – ACT Pro 2012
Hi George,
Seems like there is a conflict with your user name or your database, if you have left an apostrophe in your user name the problem will also occur.
You may change the name of your database just by simply creating a copy of your database in a new location.
You may also change the default location of the database on your hard drive and then detach the database from your SQL server and then copy the database and other needed files to the new location.