Help with backup please 1

[shiggyshag]

HI

I am using the following line in query analyzer

BACKUP DATABASE 2003 to disk = 'c:\temp\backup\2003.bak'

But it doesnt like 2003 for some reason if I change this to another database ie. vletest it works any ideas.

Cheers

 

[aroggeband]

The name of the database violates rules for identifier names which must begin with an alphabetic character or underscore. It is being mistaken for the number 2003.

Two choices:
- rename your database (may not be advisable unless you are in the process of designing it)

- use double quotation marks everywhere you refer to it:
SET QUOTED_IDENTIFIER ON
BACKUP DATABASE "2003" to disk = 'c:\temp\backup\2003.bak'

 

[shiggyshag]

Cheers muchly