Home Forums SQL Server 2005 Administering Check Statement aborted. Database contains deferred transactions. RE: Check Statement aborted. Database contains deferred transactions.

  • Enterprise edition has a feature called fast recovery. It means that, after an unexpected shutdown, the database will come online after phase 2 of the restart recovery has completed, instead after phase 3 (which the other editions do). Once the DB comes online, the rollback continues until it's complete. These are deferred transactions.

    Be patient, this is a feature, not a problem, once the rollback has finished you'll be able to run checkDB.

    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