[RadiusNT] errors in Microsoft SQL radiusnt db

Stephen Johnson ( srjohnson@integrityonline19.com )
Tue, 23 Feb 1999 11:32:34 -0600

I am using Microsoft SQL for my radiusnt db and started getting errors in
it when doing a db consistency check. I tried restoring from a known good
backup, the errors changed a little but it still hangs with the Error 605.
(It is still
authenticating and even adding new users.) Below is what is returned when
doing the dbcc, if you're really curious but what I am really looking for
help on is more a basic Microsoft SQL question. Can I just delete the
corrupt db and does the restore from the the backup restore the table,
links and everything or does the radiusnt configuration need to be
recreated and the restore just puts the data back in?

Stephen

>
>C:\WINNT\system32>SQLMAINT.EXE -S 208.209.222.7 -U sa -D radiusnt -CkDB
>-CkAl -C
>kTxtAl -CkCat -UpdSts -RebldIdx 100 -Rpt C:\MSSQL\LOG\maint_radius.rpt -To
>sysadmin
>
>Microsoft (R) SQLMaint Utility, Version 6.50.240
>Copyright (C) Microsoft Corporation, 1995 - 1996
>
>Logged on to SQL Server 'TXCOLREG1' as 'sa' (non-trusted)
>Starting maintenance of database 'radiusnt' on Mon Feb 22 12:04:33 1999
>
>[1] Check Data and Index Linkage...
>
> ** Execution Time: 0 hrs, 3 mins, 50 secs **
>
>[2] Check Data and Index Allocation...
> WARNING: Database radiusnt is currently being used by 2 user(s).
> This may cause spurious problems to be reported.
>
> The following errors were found:
>
>Table Corrupt: Page 37434 not found
>Table Corrupt: Page 506 not found
>Table Corrupt: Page 482 not found
>Table Corrupt: Page 594 not found
>Table Corrupt: Page 490 not found
>Table Corrupt: Page 538 not found
>Table Corrupt: Page 100102 not found
>Table Corrupt: Page 650 not found
>Table Corrupt: Page 882 not found
>Table Corrupt: Page 714 not found
>Table Corrupt: Page 634 not found
>Table Corrupt: Page 570 not found
>Table Corrupt: Object id wrong; tables: alloc page 512 extent id=736 l
>page#=7
>38 objid in ext=1632008845 (name = RadLogs) objid in page=1632008845 (name
=
>Rad
>Logs)objid in sysindexes=1552008560 (name = RadLogMsgs)
>Table Corrupt: Page 677 not found
>
> ** Execution Time: 0 hrs, 0 mins, 52 secs **
>
>[3] Check Text/Image Data Allocation...
>
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
>[4] Check System Data...
>
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>
>[5] Update Statistics...
>[Microsoft SQL-DMO] Error 605: [SQL Server] Attempt to fetch logical page
37434
>in database 'radiusnt' belongs to object '0', not to object
'AccountTypes'.

For more information about this list, including removal, please
see this URL: http://www.iea-software.com/maillist.html