With SQL 2000 the "DUMP TRANSACTION databasename WITH TRUNCATE_ONLY" also
works.





El Mahjoub Tarkany <el-mahjoub.[Email Address Removed]
03/25/2004 12:35 PM

To
"LazyDBA.com Discussion" <[Email Address Removed] : Re: Is there a way to remove/truncate the log file in sql 2000?







BACKUP LOG databasename WITH TRUNCATE_ONLY



suresh kumar <[Email Address Removed]
25/03/2004 11:26

Pour : "LazyDBA.com Discussion" <[Email Address Removed]
cc : (ccc : El Mahjoub Tarkany/DPI/DSTI/CLY)
Objet : Re: Is there a way to remove/truncate the log file
in sql 2000?



Hi,

Ur solution is only for 6.5. For 2000 use this command

backup log with truncate only

Rgds
Suresh

Antonio Pereyra Miranda <[Email Address Removed] wrote:
sorry , Im new
the probably soution is

DUMP TRANSACTION databasename WITH TRUNCATE_ONLY
----- Original Message -----
From: "Antonio Luis Pereyra Miranda"
To:
Sent: Thursday, March 25, 2004 9:59 AM
Subject: Is there a way to remove/truncate the log file in sql 2000?


> Is there a way to remove/truncate the log file in sql 2000?
> I have no space to backup this log with truncate option.
>
> Thanks In Advance
> Antonio from Canary Island
>

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.


Ce message contient des informations confidentielles ou appartenant au
Crédit Lyonnais et est établi à l'intention exclusive de ses
destinataires. Toute divulgation, utilisation, diffusion ou reproduction
(totale ou partielle) de ce message, ou des informations qu'il contient,
doit être préalablement autorisée. Tout message électronique est
susceptible d'altération et son intégrité ne peut être assurée.
Le Crédit Lyonnais décline toute responsabilité au titre de ce
message s'il a été modifié ou falsifié. Si vous n'êtes pas
destinataire de ce message, merci de le détruire immédiatement et
d'avertir l'expéditeur de l'erreur de distribution et de la destruction
du message.
Crédit Lyonnais, SA au capital de Euros 1.832.530.645 - RCS Lyon B 954 509
741
Siège Central : 19, boulevard des Italiens. 75002 Paris. France

This e-mail contains confidential information or information belonging
to Crédit Lyonnais and is intended solely for the addressees.
The unauthorised disclosure, use, dissemination or copying (either whole
or partial) of this e-mail, or any information it contains, is prohibited.
E-mails are susceptible to alteration and their integrity cannot be
guaranteed.
Crédit Lyonnais shall not be liable for this e-mail if modified or
falsified.
If you are not the intended recipient of this e-mail, please delete it
immediately from your system and notify the sender of the wrong delivery
and the mail deletion.
Crédit Lyonnais SA.
Share Capital of Euros 1.832.530.645.
Registered Office : Lyon (B 954 509 741)
Central and administrative Office : 19, boulevard des Italiens. 75002
Paris. France

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message is a privileged and private communication and may be read, copied and used only by
the intended recipient(s). If you are not an intended recipient, please let us know by return email.
Please then delete the message and do not disclose its contents to any person. Neither the sender nor
Toyota South Africa Motors accepts any liability whatsoever as a result of the further dissemination
of this message. Whilst all reasonable steps are taken to avoid corruption of data or information,
we do not accept any liability should such corruption occur.
MS Sql Server LazyDBA home page