To be safe our  recovery log is 10% of the size of our database. So if you
have 10GB database you should have a 1GB log

Also, When a database backup runs the recovery log should be flushing. How
often are you running datbase backups?

Good luck!
CR

__________________________________________________
Cris Robinson
Sr. Technical Analyst
Enterprise Storage Management / ADSM
Liberty Mutual Insurance
Portsmouth, New Hampshire
603.431.8400.54837
mailto:cris.robinson AT libertymutual DOT com

Dilbert words of Wisdom:
Accept that some days you're the pigeon,
and some days you're the statue!

        -----Original Message-----
        From:   Kevin Lipscomb [SMTP:klipscom AT DANRIVER DOT COM]
        Sent:   Tuesday, May 25, 1999 10:20 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        help

        Hi all,
        I am very new to ADSM (I can barely spell it) and am having a
problem that
        I understand is fairly widespread. At the rate of embarassing myself
here
        goes:
        We are running 3.1.1.2 on AIX, and our recovery log though set to
normal
        mode is growing exponentially, I need to find a way to "prune" this
monster
        before it takes over our machine.
        If someone could help me that would be great.
        Regards,
        Kevin Lipscomb
        System Engineering
        Dan River Inc.