Home Forums SQL Server 2005 Data Corruption Multiple databases constantly going into Recovery Mode RE: Multiple databases constantly going into Recovery Mode

  • Autoclose is on for those databases. So whenever no one's using the DB, SQL shuts it down. When you need it again, SQL starts it up and recovers it (going through recovery)

    Maybe also log fragmentation (excessive VLFs)

    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