Re: RadiusNT with SQL server

Dale E. Reed Jr. ( (no email) )
Mon, 29 Dec 1997 20:57:31 -0800

Endang Rachmawati Adwiarto wrote:
> For SQL server experts out there,
> I'm using radiusNT 2.2 with SQL ODBC.
> I've ran it for about 3 months and my transaction log is building up.
> I tried to truncate it but the log space availability didn't increase its
> availability size.
> Anybody knows how do truncate the log size totally to zero?
> The situation of my log size compared to the data size is as follows:
> Log size: 1413 MB and -->Log Space Available178.69 MB
> Data size: 907 MB --> Data Space available:623.54 MB

Run the following on your database and then truncate the log:

DBCC CheckDB(Emerald)

Where Emerald is you database name.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |