none
What to do when Replica becomes inconsistent? RRS feed

  • Question

  • Sometimes I see that there is a red cross against a DB and it says "Replica is inconsistent".

    How to troubleshoot this and fix it?

    I tried the following

    1. Perform consistency check - had no effect?

    2. Right click on the DB and say "create recovery point" - gave an error that recovery point cannot be created for a database with inconsistent schema.

    Tuesday, March 8, 2011 7:39 AM

Answers

  • This will depend on what the error is.  Often these errors will correct themselves automatically as the auto-heal functionality will kick in.  In circumstances when you are not able to wait for the auto correction or if this is somethign auto-heal does not correct, then you would need to look in the monitoring tab for the failed database.  This is where you will likely find more information as to what failed and possible reasons/resolutions.  That is the information we would need in here as well in order to help you determine what your possible solutions would be.
    Thanks, Chris Butcher - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    • Marked as answer by MSDN Student Wednesday, March 9, 2011 11:11 AM
    • Unmarked as answer by MSDN Student Wednesday, March 9, 2011 11:11 AM
    • Marked as answer by MSDN Student Wednesday, March 9, 2011 11:12 AM
    Tuesday, March 8, 2011 4:49 PM
    Moderator