Why does BACKUP LOG... not parse properly

[CInman]

For some reason, the following command generates an error when parsed:

BACKUP LOG joebloggs WITH TRUNCATE_ONLY

and the error when parsed is:

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

Does anyone know why?

 

[SQLBill]

Is joebloggs your DATABASE name?

The correct syntax is:

BACKUP LOG databasename WITH TRUNCATE_ONLY

The command LOG lets it know to take the action on the LOG for the DATABASE named.

-SQLBill

 

[CInman]

Yeah, that is the database name, which is why I don't understand it?

 

[SQLBill]

I don't understand either. I checked the BOL and that's the correct syntax. Which database are you in when you parse it (ie. in Query Analyzer which database does it show you are using? or which one is in your USE command.)

-SQLBill

 

[tlbroadbent]

Which version of SQL Server are you running? Is the Backup command the only command in the batch?

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm