Error 815

Severity Level 21

Message Text

Unable to find buffer holding Sysindexes page in the cache - pageno = %1d dbid = %d

Explanation

This error occurs when SQL Server cannot find the structure that determines where a particular page of the sysindexes system table is cached in memory.

The occurrence of this error may indicate other structural issues in the database referenced by the dbid value in the referenced text. Determine the database being referenced. Use:

SELECT db_name(dbid)

Action

If the database referenced is tempd, shut down and restart SQL Server.

If this error occurs frequently or in a user database, execute DBCC CHECKDB and DBCC NEWALLOC. Contact your primary support provider and have the results from the DBCC CHECKDB and DBCC NEWALLOC, as well as the SQL Server error log available for review.