• First, you need to look at what recovery model the database is in. You can get that by looking at the Options tab in the properties. (Right-click the database in Management Studio to get to the properties.)

    If it's in Full recovery mode, then you need to check on whether or not log backups are being done.

    If it's in Simple recovery mode, then you need to look at long-running transactions that might be filling it up.

    What you do from there depends on what you find.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon