Post reply

SOS - Backups fali error 23 redundancy check falis

  • February 2, 2015 at 6:52 am

    #295053

    Automated and manual backup done through SQL Management console are failing with error 23 - redundancy check failed.

    This is a critical production db. Other db in same instance backs up ok.

    Is there a way to fix this?

  • February 2, 2015 at 7:04 am

    #1774769

    What's the exact command and exact error that you're getting?

    When did you last run CheckDB on that database?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 2, 2015 at 8:28 am

    #1774794

    Thanks for replying. I am new to SQL admin. I have not run CheckDB.

    Full error message is:

    Backup failed for Server 'Active02'. (Microsoft.Sql|Server.SmoExtended)

    Additional information:

    System.Data.SqlClient.SqlError: Read on"E:\Class Database\Class.mdf" failed: 23(Data error (cyclic redundancy check).) (Microsoft.Sql|Server.Smo)

    Any suggestions?

    Eddie

  • February 2, 2015 at 2:50 pm

    #1774893

    Just a final note:

    I worked with MS Support and was able to resolve my problem.

  • February 3, 2015 at 12:50 am

    #1774951

    eal1 (2/2/2015)

    Just a final note:

    I worked with MS Support and was able to resolve my problem.

    So what went wrong and how did you fix it?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply