Re: Radius Nt with SQL 6.5, Transaction Logs filling up

Dale E. Reed Jr. ( (no email) )
Sun, 08 Mar 1998 12:46:58 -0800

Mike Miller wrote:
>
> >Try a dbcc checkdb on that table. That should reset the counters.
> >You'll then need to restart the SQL Server process. There is a bit of a
> >bug where SQL Server will report a full log even after it has been
> >truncated!
>
> I just got the chance to try this (had to wait until a scheduled time in
> case something went wrong), unfortunatelly with no luck. Our database is
> now about 101MB and our transaction log is 705MB (7 times larger almost!)
> Any suggestions?

What options do you have enabled for the database?

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com