Help: Can't backup database with " - " character in the database name

[sunt]

Hi Expert,
I tried to dump a SQL 7.0 database to a remote share using:
BACKUP DATABASE COLD-SYSTEM TO DISK='\\SERVER1\BACKUP\COLD.BAK'
However, when I executed the command. It gave me that :
Incorrect syntax near '-'

I have tried another database name with no '-' eg. pubs. It works fine and can dump to remote share.
I also checked the sysdatabases table and it does contain the database COLD-SYSTEM.
Is my command wrong or the backup command can't handle '-' character? I also tried the dump command, result the same.

Your help is appreciated.
Thanks
Sunt

 

[RobertT687]

Enclose the database name in brackets like so:
BACKUP DATABASE [COLD-SYSTEM] TO DISK='\\SERVER1\BACKUP\COLD.BAK'

 

[sunt]

Hi RobertT687,

It is working!
Thanks a lot!
Sunt