T-SQL script for tran log with - in database name

[Mike]

Hi,

This is probably a trivial question, as I am simply trying to execute a
BACKUP LOG database WITH NO_LOG. Except T-SQL will not accept anything
I type when database has a - in it, for example data-base. I have
tried:

BACKUP LOG 'data-base' WITH NO_LOG
BACKUP LOG "data-base" WITH NO_LOG
BACKUP LOG (data-base) WITH NO_LOG
BACKUP LOG N'data-base' WITH NO_LOG
BACKUP LOG N"data-base" WITH NO_LOG
BACKUP LOG N('data-base') WITH NO_LOG
BACKUP LOG N("data-base") WITH NO_LOG

All T-SQL will tell me is "syntax error" and Books Online has no
information. So... ???

Thank you!

[Simon Hayes]

BACKUP LOG [data-base] WITH NO_LOG

See "Delimited Identifiers", "Using Identifiers" and QUOTENAME() in
Books Online. It's usually best to stick to letters and digits only for
identifiers.

Simon