CODEWITHSUNDEEP
sql-serverremote-backup
sony
sony

Reputation: 21

SQL Server 2005 full database backup to disk

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

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300837

Should be:

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

[Note: square brackets]

See Identifiers

Upvotes: 1

Related Questions