Truncating SQL tables

Andras Tudos - Computronic, C3 ( (no email) )
Thu, 15 Jan 1998 06:07:34 +0100

What is the most efficient method to keep the calls table below a specific
size? Our problem: if we run a copy and delete query, then during the
delete process nobody can log in and RadiusNT hangs (sometimes it recovers,
sometimes not). Any ideas?

For example it would be a great help if we could define a backup user with
attributes to be returned for all incoming calls when SQL Server is
unreachable. This way all SQL maintenance could be done without
interrupting the user service. (I know we could have a second SQL Server,
but ...)

Andras Tudos
C3, Budapest