database (in recovery) , what is the normal cause

• kingsofconvenience

  Old Hand

  Points: 326

  More actions

  May 12, 2010 at 7:39 pm

  #140270

  recently my databases in SQL2005 sometimes suddenly try to recovery (i.e. database (in recovery) .

  may someone kindly teach what is the normal cause ?

  how to further check the reason behind ?

  Thanks in advance.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736504

  More actions

  May 12, 2010 at 8:53 pm

  #1166600

  Recovery normally runs when a database is first started or opened. Have you checked the error log (SQL error log) for entries?