I thought that originally but its not required for WITH TRUNCATE_ONLY
The syntax being used seems to be correct - we use it as an ad hoc procedure to reduce log file size.
Stuart
>>> "Mark Harr " <mssqldba-ezmlmshield-x20953631.[Email address protected] 05/28/04 01:38pm >>>
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]
>
>
>
---------------------------------------------------------------------
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]
*************************************************************************************
The contents of this email are confidential to the intended recipient.
It may not be disclosed to or used by anyone other than the addressee,
nor may it be copied in any way. If received in error, please contact
the company on 01234-791388, then delete it from your system. Please note
neither the company nor the sender accepts any responsibility for viruses
and it is your responsibility to scan attachments (if any) for viruses.
No contract may be concluded on behalf of the company by means of email
communications.
*************************************************************************************
MS Sql Server LazyDBA home page