Reputation: 21
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.
Upvotes: 2
Views: 1087
Reputation: 300837
Should be:
BACKUP DATABASE [10997_diamondtransportinccom] TO DISK = 'D:\10997diamond.BAK'
[Note: square brackets]
See Identifiers
Upvotes: 1