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
hi Convoluted, do this: osql -U sa -P password -S mypc -Q "BACKUP DATABASE [995] TO DISK 'C:\TEST_BACKUP\995.BCK'"
Rate one work.
Reply to
Akber Alwani

Site Timeline Threads

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.