Error: 913 problem -
09-22-2004
, 07:09 AM
We work on a sybase 12.0 and found the following error in error log
recently:
00:00000:00252:2004/09/18 05:45:16.20 server Error: 913, Severity: 22,
State: 2
00:00000:00252:2004/09/18 02:45:16.20 server Could not find row in
sysdatabases with database id 0. Run DBCC CHECKTABLE on sysdatabases.
From the Sybase troubleshooting guide, it is mentioned that this error
occurs when Adaptive Server cannot find an entry in sysdatabases when
looking for a specific database ID. There are some possible causes of this
error, but how can I know which one caused this error (any procedure can be
checked?). Actually, we have NOT drop or re-created or renaming the db
before, but why there is reference wrong dbid??
Somebody advise us to reboot the server or run dbcc dbrepair to fix this
error, but Sybase guide advise to use the sp_fixindex stored procedure to
repair the index or restore master from backup.
But we want to know what had happen and which recovery procedure can be
used?? Please help and advise......Many thanks!!! |