Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backing Up SQL database via query analyzer 1

Status
Not open for further replies.

joepc

MIS
Jul 26, 2002
647
US
Having trouble backing up our SQL database via query analyzer. Running the command below but I am receiving an error when I try and run it. If I replace the DB name with master or northwind it works fine.


BACKUP DATABASE 1111cu
TO DISK = N'c:\test.bak'
WITH STATS = 5

ERROR:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '3209'.


Anyone have any idea's??? Thanks!!!
 
Try

BACKUP DATABASE [1111cu]
TO DISK = N'C:\test.bak'
WITH STATS = 5
GO
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top