sorry , Im new
the probably soution is

DUMP TRANSACTION databasename WITH TRUNCATE_ONLY
----- Original Message -----
From: "Antonio Luis Pereyra Miranda" <[Email Address Removed] <[Email Address Removed] 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
>
MS Sql Server LazyDBA home page