Error 2520

Severity

16

Message text

Database named %.*s not found; check sysdatabases

Explanation

This error occurs when Adaptive Server is unable to find the database that you specified when when you ran dbcc checkcatalog, dbcc checkdb, or dbcc dbrepair.

Possible reasons for this error are:

Action

Determine whether the database specified in the error message exists:

1> sp_helpdb
2> go

Search the output to determine whether you misspelled the database name or whether the dbid for the database you specified exists but the name has been removed or changed.

If the database you are specifying exists and you are getting a 2520 error, run dbcc checkdb on the master database to find out whether it is corrupt. If dbcc checkdb returns error messages, corruption has occurred. Whether or not you believe corruption has occurred, contact Sybase Technical Support. You may be able to rebuild the indexes for master or you may have to restore master from a backup.

Additional information

Before calling Sybase Technical Support, have the information available that is listed in “Reporting errors”, including the output of dbcc checkdb.

Versions in which this error is raised

All versions