Error 1109

Severity Level 21

Message Text

Attempt to read allocation page %ID failed either because object ID is not correct (%Id) or the page ID is not correct (%ID).

Explanation

This error occurs when SQL Server attempts to read the specified allocation page and finds a page belonging to another object instead. The allocation page is used to control the allocation of the next 255 pages in the database. This error is equivalent to a 605 error on any other object. It is almost always caused by hardware- or operating-system-level problems.

Action

An allocation page cannot be repaired. Restore from backup. It is often possible to bulk copy out the data from your tables if there are no other errors in the database.

Run hardware diagnostics and correct any problems. Contact your hardware vendor and confirm that you are running your system with the most current updates. You should also confirm that the hardware and controllers are certified for your operating system.