1 {{ upvoteCount | shortNum }}
1 {{ upvoteCount | shortNum }}

SQL SERVER

by Lavigne087
1 replies
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?
#server #sql
  • Profile picture of the author noah.whitmore
    First result when I Google'd your error message...

    https://support.microsoft.com/en-us/kb/2015739

    Quoting from that page...

    A query can fail with an error like the following if it needs to read a database page where the allocation unit as stored in the page header (also referred to as the actual allocation unit) does not match the expected allocation unit based on table(s) referenced in the query.

    ...

    This problem could be an issue with the database page or a problem with the SQL Server engine when determining what the expected allocation unit should be.
    I would check to section of that page which is titled 'Resolution' and it should tell you what you need.

    -Noah
    Signature
    No Pitch For The Moment - Just A Nice Hello.
    So... 'Hello'
    Feel free to PM me if you have any questions about my posts. I'd like to hear from you!
    {{ DiscussionBoard.errors[10612702].message }}

Trending Topics