BACKUP LOG databasename WITH TRUNCATE_ONLY




suresh kumar <[Email Address Removed] 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
MS Sql Server LazyDBA home page