06-16-2010 04:43 AM
When attempting to backup database get the following error message:
Incorrect syntax near the keyword 'Database'.
Incorrect syntax near the keyword 'With'. If this statement is a common table expression or an xmlnamespace clause, the previous statement must be terminated with a semicolon.
PRC_MAINT_BACKUPDB: ERROR EXECUTING DATABASE BACKUP STATEMENT
The first error 'Database' may be related to the folder name, Database-database files, produced when started from the .ADF file.
OS Win 7 Home Premium.
Help to solve both problems would be appreciated
06-16-2010 07:25 AM
I see a reference to 'Database-database files', is the name of your database "Database"?
If it is, was this converted from a previous version of Act!?
Have you ever been able to create a backup?
06-16-2010 07:38 AM
06-16-2010 08:08 AM
Yes the name was Database and it was converted from v2009. I have not backed up this database since moving from v2009 as it is in My Documents on a partition that is backed up daily. I am attempting to move the database to a laptop for use when out of town.
06-16-2010 06:43 PM
That fixed the problem. Strangely I had to switch to Administrator to be able to copy the database. Once copied and switched back to my own login the database opened without a hitch and can now be backed up.
Great - Thanks for the help.