Error 813

Troubleshooting SQL Server

Troubleshooting

Error 813

Severity Level 20
Message Text

Logical page %S_PGID in database ID %d is already hashed.

Explanation

This error occurs when Microsoft® SQL Server™ attempts to hash the logical page %S_PGID of database ID%d and the page is already in the SQL Server hash table.

This error usually occurs as a side effect of other data errors that can usually be detected by executing DBCC CHECKDB without a repair clause.

Action

Review the SQL Server error log, and then execute DBCC CHECKDB with the appropriate repair clause on the database. If the error involves an index page, use the REPAIR_REBUILD clause. If the error involves a data page, it may be necessary to use the REPAIR_ALLOW_DATA_LOSS clause. In the likely event that you cannot allow the loss of data, you will need to restore from a known clean backup. If the problem persists, contact your primary support provider. Have the output from DBCC CHECKDB available for review.

Important  If executing DBCC CHECKDB with one of the repair clauses does not correct the index problem or if you are unsure what effect DBCC CHECKDB with a repair clause has on your data, contact your primary support provider.

Verify with your hardware vendor that the disk subsystem being used by SQL Server is at the currently supported and recommended firmware and hardware levels.

If DBCC CHECKDB finds no errors, or if errors are found and corrected so that subsequent DBCC statements indicate no errors, but this error reoccurs, contact your primary support provider. Have the SQL Server error logs and the output from DBCC CHECKDB and sp_configure available for review.

See Also

DBCC CHECKALLOC

DBCC CHECKDB

Errors 1 - 999

Reporting Errors to Your Primary Support Provider

Setting Configuration Options

sp_configure