Skip to main content

SQL Server

Beginner
Posts: 1
Comments: 0

I get the following error messages when an application submits a query:

Msg 605, Level 21, State 3, Line 1
Attempt to fetch logical page (1:224) in database 11 failed. It belongs to allocation unit 72058253744865280 not to 72057594040287232

What’s wrong?       

Forum Star
Posts: 57
Comments: 2180

Top

Eric,

Thank you for your posting. Could you please provide more information on the issue:

  • exact product name and build you are using
  • when exactly the error message appears, if possible attach a screenshot
  • please attach the whole error message

Thank you,

Beginner
Posts: 0
Comments: 1

Top

If DBCC CHECKDB or CHECKTABLE reports an error (which should be Msg 2533), then the page is damaged or an incorrect page. You should restore from a backup to resolve the problem. If you cannot restore from a backup, use the repair options with DBCC CHECKDB. To find the cause of this problem you should use techniques as you would with other database corruption errors including:

Check for hardware or system level problems (A tool such as SQLIOSIM can be helpful to do this. SQLIOSIM ships with SQL Server 2008 and SQL Server 2008 R2 and does not require a separate download)

Ensure you have the PAGE_VERIFY=CHECKSUM database option turned on. While it is possible to still encounter a Msg 605 error with checksum enabled (Ex. "scribbler" problem or incorrect page provided from I/O system), enabling checksum can provide definitive proof that the page was modified incorrectly within the I/O system.

Try to restore a database backup you know that will be "clean" (no errors from CHECKDB) and transaction log backups you know span the time when the error was encountered. If you can "replay" this problem by restoring a "clean" database backup and transaction logs then contact Microsoft Technical Support for assistance.

For more information about database corruption problems see here: https://www.fixtoolbox.com/sqlserverfix.html SQL Server Fix Toolbox