by You need to truncate or dump the log.
To manually dump (and perhaps backup your log) use DUMP DATABASE yourdb TO
DISK = '<path on server' WITH INIT
To set SQL to auto dump the log..
sp_dboption 'trunc. log on chkpt.','yourdb',true
When the log is truncated the stats showing the %used are out-of-date, use
dbcc checktable(syslogs) in the database your using to update.
--
Tony Rogerson
Torver Computer Consultants Ltd.
begin 666 Tony Rogerson.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E)O9V5R<V]N.U1O;GD-"D9.
M3U1%1"U04DE.5$%"3$4Z.SM4;W)V97(],$0],$$R-B!-;V]R;&%N9"!2;V%D
M.TAA<G!E;F1E;CM(97)T9F]R9'-H:7)E.T%,-2 T3$$[16YG;&%N9 T*3$%"
M14P[5T]22SM%3D-/1$E.1SU154]4140M4%))3E1!0DQ%.E1O<G9E<CTP1#TP
M03(V($UO;W)L86YD(%)O860],$0],$%(87)P96YD96XL($AE<G1F;W)D<VAI
M150Z=&]N>7)O9V5R<V]N0&-O;7!U<V5R=F4N8V]M#0I2158Z,3DY.# V,C94
`
end
end