backup the log file then shrink the file, if you do not require point in
time recovery, set the recovery mode to simple.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view] "manny" <anonymous@discussions.microsoft.com> wrote in message
news:642f01c3e603$7c99cb10$a501280a@phx.gbl...
> our logfile run out of space and we canot transact
> anymore,what shall i do?