> My radlogs keeps growing, is there a query I can run to delete all the logs? I don't need the bad logins back several months.
Use SQL Enterprise Manager to install a SQL Executive TSQL command that
runs once a night and is:
Delete From Calls Where AcctStatusType=1
Go
Delete From RadLogs Where DateDiff(Day, LogDate, GetDate()) > 14
GO
Change the value to your liking. This will keep your DB trim
automatically.
Dale E. Reed Jr. (daler@iea.com)
_________________________________________________________________
IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
Internet Solutions for Today | http://www.iea-software.com