1. Home
  2. Point-Of-Sale Software
  3. Backup batch file error

Backup batch file error

Created batch file as... osql -U sa -P password -S mypc -Q "BACKUP DATABASE 995 TO DISK 'C:\TEST_BACKUP\995.BCK'"

when I run it, I get error mssg is "incorrect syntax near '995'

the database name is 995; I tried using single quotes between 995 but to no avail - same error mssg

I appreciate any help on this - thanks

Reply to
convoluted
Loading thread data ...

hi Convoluted, do this: osql -U sa -P password -S mypc -Q "BACKUP DATABASE [995] TO DISK 'C:\TEST_BACKUP\995.BCK'"

Rate >

Reply to
Akber Alwani

Reply to
convoluted

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.