We run a second copy of RADIUSNT on another machine that also has the SQL
client intstalled on it. Every 3 hours, a batch file runs that uses the
RADUSERS program to query the main database and create a new USERS file.
The batch file checks the integrity of the USERS file before copying it
over the existing one, as a corrupt/useless file is created if the SQL
server isn't working.
We can shut down the main server, running Emerald, SQL Server, and RADIUSNT
and everything will keep right on keeping on. Adding users can be a bit
problematic, but we could even do that with a text editor if we have a
long-term emergency or outage on the main machine.