Perhaps missing the TO clause?

From BOL:

Backing up a transaction log:

BACKUP LOG { database_name | @database_name_var }
{
TO < backup_device > [ ,...n ]

....



=======================
Mark Harr


> -----Original Message-----
> From: Christopher Iain
> [mailto:mssqldba-ezmlmshield-x48152272.[Email address protected]
> Sent: Friday, May 28, 2004 2:42 AM
> To: LazyDBA.com Discussion
> Subject: BACKUP LOG Problem
>
> ___________________________________________________________
> All information and opinions expressed in this message and/or
> any attachments are those of the author and not necessarily
> those of Schroder Investment Management (Luxembourg) S.A.,
> and affiliates. There is no guarantee that this message is
> either private or confidential, and it may have been altered
> by unauthorised sources without your or our knowledge.
> Nothing in the message is capable or intended to create any
> legally binding obligations on either party and it is not
> intended to provide legal advice. Schroder Investment
> Management (Luxembourg) S.A. accepts no responsibility for
> loss or damage from its use, including damage from virus.
>
> Hello,
> I am trying to backup a log to truncate it. I am using the
> commands below
> but both give me the errors. The other databases on the
> server didn't have
> this problem.
>
> BACKUP LOG SIM WITH TRUNCATE_ONLY
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near 'SIM'.
>
>
> BACKUP LOG [SIM] WITH TRUNCATE_ONLY
> Server: Msg 170, Level 15, State 1, Line 3
> Line 3: Incorrect syntax near 'SIM'.
>
> Any ideas on how to get this to work?
> Thank
> Iain
>
> SQL2000 sp3
>
>
> __________________________________________________________________
>
> Confidentiality Notice
>
> This message may contain privileged and confidential
> information. If you think, for any reason, that this message
> may have been addressed to you in error, you must not
> disseminate, copy or take any action in reliance on it, and
> we would ask you to notify us immediately by return email to
> "[Email address protected]
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>

MS Sql Server LazyDBA home page