View Single Post
Old 12-15-2008, 05:57 AM   #9
superspugg
New Member
 
Join Date: Dec 2008
Model: pearl
PIN: N/A
Carrier: O2UK - Telefonica
Posts: 7
Default

ok so I have made some progress this morning. I finally managed to piece together the correct syntax to access the instance.

osql -E -S 3t-auto-6\SQLBES
1>

but then I am still having the incorrect syntax near '3' error when trying to back up the database with this command

backup database 3TBES to disk = "C:\3TBES.bak"

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\besadmin>d:

D:\>osql -E -S 3t-auto-6\SQLBES
1> backup database 3TBES to disk ="C:\3TBES.bak"
2> go
Msg 170, Level 15, State 1, Server 3T-AUTO-6\SQLBES, Line 1
Line 1: Incorrect syntax near '3'.
1>
Offline   Reply With Quote