Home Forums SQL Server 2008 SQL Server 2008 - General DB is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore. RE: DB is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.

  • Be extremely cautious using repair_allow_data_loss. There is zero guarantee that it will fix the problem by dropping one or two pages worth of data. It can, in some cases, nuke the entire database. My first resort would be to restore the database from a tested good backup. Or, drop the table, run DBCC to see if that resolves the issue, then restore the database to a second location and copy the data over from the original table. Either of these is safer than doing what you're proposing.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning