Home » Topic » How to remove SQL server Page level Corruption

How to remove SQL server Page level Corruption

Eddie Thwan ~ Modified: October 28th, 2017 ~ ~ 1 Minute Reading

Home Forums How to remove SQL server Page level Corruption

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #5480 Score: 0
    Eddie Thwan
    Moderator
    44 pts

    Whenever any of the applications connected to my SQL Server database submit a query, I am getting the following message

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

    I am not able to successfully execute the query after this error pops up on screen. Can anyone explain why this is happening?

    #5486 Score: 0
    Sandra Diaz
    Moderator

    Hey,

    You may be getting this error message due to the fact that the pages in your SQL server database have become corrupted. Possible reasons for page level corruption to occur include

    • Hardware Faults
    • Virus or Trojan intrusion
    • Unreliable Power Supply
    • Erroneous Updates
    • Server Issues

    Did you experience any of the described conditions before, with your SQL Server Database?

    #5492 Score: 0
    Eddie Thwan
    Moderator
    44 pts

    Hello,

    I wasn’t able to pinpoint the exact cause until now. I think my SQL Server pages might have become corrupted due to a recent software update that I installed.
    In any case, is there any way to bring back the damaged pages to a normal healthy state so that I can work with my important data?

    #5496 Score: 0
    Sandra Diaz
    Moderator

    If you want to remove SQL Server Page corruption manually perform the steps as given below

    1. Use a comparison tool to check the variation between corrupted MDF and original MDF
    2. Execute DBCC CHECKDB on the suspected file
    3. To check the contents of the page which is shown as corrupt by the CHECKDB command, run DBCC PAGE commands.

    Make sure you perform all the commands carefully and let me know if this helps you.

    #5502 Score: 0
    Eddie Thwan
    Moderator
    44 pts

    I am currently in a rush to perform some operations on my SQL server database and I do not have the time to perform such a long list of complex commands. Is there any simpler alternative which would allow me to remove SQL Server Page level corruption quickly?

    #5506 Score: 0
    Matt Johnson
    Moderator

    Hey Eddie,
    I completely understand the problem you’re facing. To assist you in getting rid of it within a few clicks I would suggest that you should make use of a third party software such as SQL Recovery Tool which worked wonders for me!

    Find out more about this useful utility here: http://lettoknow.com/remove-sql-server-page-corruption/

    Hope it helps!

    Cheers!

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.