Suspect mode in sql server 2005

• subha.mcts2005

  SSC Eights!

  Points: 928

  More actions

  October 19, 2010 at 1:23 am

  #227989

  Hi,

  what are the ways to database goes to Suspect mode in sql server 2005?

  i found that Datafile/Logfile full , drive runs out of disk space & h/w problems will lead to structurally damage to the DB.

  any other ways apart from above, plz tell me

  Subhash

  DBA.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  October 19, 2010 at 9:30 am

  #1239131

  Data/Log files missing or inaccessible

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga