I am trying to back up a database. I am using SQL Server 2005 and am in MS SQL Server Management Studio Express. I have attempted to run the following script:
BACKUP DATABASE 209-9-1-PT
TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\209-9-1-PT.bak';
I get the error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '209'.
What is the problem?