Solved

Database Backup Error

Posted on 2009-07-15
3
178 Views
Last Modified: 2012-05-07
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';
GO

I get the error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '209'.

What is the problem?
0
Comment
Question by:lmred
  • 2
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 50 total points
ID: 24859745
BACKUP DATABASE [209-9-1-PT]
 TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\209-9-1-PT.bak';
GO
0
 
LVL 1

Author Comment

by:lmred
ID: 24859899
chapmandew you are good and fast! Thanks so much. I knew it was something dumb I was missing.

lmred
0
 
LVL 1

Author Closing Comment

by:lmred
ID: 31603741
Thanks again!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now