SQL Server 2005 full database backup to disk

Question

I'm trying to do a full backup of my database by entering the following:

BACKUP DATABASE 10997_diamondtransportinccom
TO DISK = 'D:\10997diamond.BAK';

But it gives me the following error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '10997'.

Please advice. Thanks.

Answer 1

Should be:

BACKUP DATABASE [10997_diamondtransportinccom] TO DISK = 'D:\10997diamond.BAK'

[Note: square brackets]

See Identifiers