Re: [RadiusNT] The ever growing db...

Dale E. Reed Jr. ( (no email) )
Wed, 26 May 1999 10:29:21 -0700

Gabriel wrote:
> I'm pretty sure this has been asked before, but I just wanted to check up with
> you guys before I did anything.
> I have a RadiusNT device sized at 400mb.
> Day 1: Radius db was 17.4mb
> Day 2: Radius db was 33.0mb
> Day 3: Radius db was 65.0mb
> Day 4: Radius db was 101.0mb
> As u can see, I stupidly created the database and it's log all in the same db
> and device. Yes, I know I'm dumb. But, how do we safely remove delete
> the transaction logs to get the db back down to size. Plus, is there a way
> I can safely split or recreate this database and transfer the data over
> to a new one with a separate data and log database & device.

Create a seperate DB Device, that is LARGER than your current log space
in use. Then expand your database LOG segment onto that new device.

Also, for the database, check the "truncate log on checkpoint" and it
will keep the log down. Running a CheckDB will always help as well.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.