database in suspect mode

• shuzi

  Say Hey Kid

  Points: 684

  More actions

  March 24, 2008 at 3:18 pm

  #188386

  If i need to query the system databases to find out witch database is in suspect mode, what would be the tables and the field of the value?I use the query select * from master..sysdatabases

  where status & 256 = 256

  ,i check the status field of the database, it is 16, but

  on Enterprise manger, i saw that besides the database name it specified

  (Suspect), also i use SELECT DATABASEPROPERTY('dbxxx', 'IsSuspect') it return

  false. So why exactly it showes suspect? thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736642

  More actions

  March 24, 2008 at 9:24 pm

  #793317

  Have you refreshed EM to be sure it's not old? Also check the error log to see if there's a suspect entry in the log and what the error is.