Using Extended Proc on DB with Spaces in the Name
Output from SQL Backup (3.1.0)
SQL Backup 3.1.0, (c) Red Gate Software Ltd 2004 - 2005
Serial number: 010-010-020941-7208
Syntax error: [ after DATABASE
(3 row(s) affected)
Using the GUI, the backup runs fine, however, using the GUI to Generate the Extended proc Script and then Executing it in QA gives the above output.
Here is the GUI generated Script:
master..sqlbackup '-SQL "BACKUP DATABASE [Citrix SQL Store] TO DISK = ''F:\FULL_(local)_Citrix SQL Store_20050511 115154.sqb'' WITH NAME = ''Database (Citrix SQL Store), 5/11/2005 11:51:34 AM'', DESCRIPTION = ''Backup on 5/11/2005 11:51:34 AM Database: Citrix SQL Store Instance: (local) Server: UAFCWSTSRV3'', COMPRESSION = 3" -E'
Any ideas or suggestions for a workaround are welcome. I have a nice Proc I made to backup all DBs, but this DB blows the proc up. Currently we have to exclude it from SQL Backup and have scheduled the regular slow and fat backup process.
...By the WAY...... Spaces in the name WAS NOT MY DOING..GRR