05-26-2011 04:31 PM
When I attempt to backup my dB, I get the following error message:
"Incorrect syntax near '\'.
Unclosed quotqtion mar4k after the character string ' ,NOSKIP,
STATS = 10, NOFORMAT',
PRC_MAINT_BACKUPDB:ERROR EXECUTING DATABASE BACKUP STATEMENT
As a result, the backup is canceled. Don't understand what is wrong.
05-27-2011 06:34 AM
This is generally seen when the path to the database files contains a special character (ex: apostrophe). The default location for a database is under the path containing the Windows Username, which can be created with special characters. The resolution to this issue is to move your database to a new location. General steps: create a new folder on the C: drive (ex: C:\Act Database) and move the database into the new folder.
Here is an article with more in-depth instructions: KB Article 13740
05-27-2011 01:02 PM