making a log file smaller

I have a log file that is pretty big (700 MB). The mdf
file is at 200 MB. How can I make the log file smaller
without destroying the integrity of the database?
Thanks for any help.If you do not require transactional recovery, for the short term do a
"backup log dbname with truncate_only"
for the long term set the recovery mode to simple.
If you do require transactional recovery, schedule timely log backups.
Once you backup the log or truncate it, work with dbcc shrinkfile to shrink
the footprint, see BOL for syntax. You shouldn't try to keep the log as lean
as possible as if it has to reallocate space to grow during the production
day that is a performance hit. Lots more info on transactional logs in BOL.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"dre" <anonymous@.discussions.microsoft.com> wrote in message
news:027201c394d0$f4e802a0$a101280a@.phx.gbl...
> I have a log file that is pretty big (700 MB). The mdf
> file is at 200 MB. How can I make the log file smaller
> without destroying the integrity of the database?
> Thanks for any help.