I recently Took over as Database Administrator for a Small Mortgage Firm in the Charlotte Area. The Databases have been poorly maintained for the last three years, with issues such as 3Gig Datafiles and 100G Transaction Files. I have backed up all the databases and reset the Transaction Logs to Restricted growth. The Problem is that on the Main Production Database the Transaction Log grows at about 50Megs a Day,which is fine, but in the smaller less used Database the Tranaction Log is Growing by 500Megs a Day. I have run the profiler against the Database and the Main gets about 5K hits a day and the Smaller Gets about 50 Hits a day. Does Anyone have any idea why there would be such a growth difference?

Brad