Yes the syntax was correct.
I have found the error. Someone set the Compatibility Level to 65.
Thanks
Iain
-----Original Message-----
From: Christopher Iain
[mailto:mssqldba-ezmlmshield-x48152272.[Email address protected]
Sent: 28 May 2004 08:42
To: LazyDBA.com Discussion
Subject: BACKUP LOG Problem
* Please Note : This message was received from the Internet *
_____________________________________________________________
___________________________________________________________
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