Error 908

Severity

22

Message text

Unable to find any entries in Sysusages for  dbid '%d',database '%.*s'. Run DBCC CHECKTABLE on Sysusages in the master  database. 

Explanation

The master..sysusages table keeps track of the space that you assign to Adaptive Server databases. create database and alter database allocate new space to the database by adding a row to sysusages for each database device or device fragment.

The Database Manager maps logical pages (pages in an Adaptive Server database) to virtual pages (pages in a database device). There is a one-to-one correspondence between these two types of pages.

Error 908 occurs during recovery when Adaptive Server attempts to generate the mapping of logical to virtual pages for a specified database, but is unable to find any rows for the database in the sysusages table.

Action

Check the sysusages table:

1> use master
2> go

1> dbcc checktable(sysusages)
2> go

If errors are reported, try to fix them using the sections in this manual that describe those errors.

If dbcc checktable reported no errors, and you do not need to recover the database in question, remove the database from your Adaptive Server installation. For further information, refer to “Dropping a database when drop database fails” in the chapter “Other Useful Tasks” in the most recent version of Troubleshooting and Disaster Recovery. After removing the database, restart Adaptive Server and check that the 908 error is eliminated.

If dbcc checktable reported no errors, but you need to recover the database in question, start by removing the database from your Adaptive Server installation as described above. Next, rebuild the database using your creation scripts, and reload it from a clean backup.

Versions in which this error is raised

All versions