dbTalk Databases Forums  

Error: 913 problem

comp.databases.sybase comp.databases.sybase


Discuss Error: 913 problem in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jerke szabo
 
Posts: n/a

Default 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!!!




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.