database in suspect mode - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

database in suspect mode

Author

Topic

maryxu
Starting Member

36 Posts

Posted - 2008-03-19 : 11:28:50

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? thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-19 : 13:30:59

Table: Sysdatabase
Field: Status

maryxu
Starting Member

36 Posts

Posted - 2008-03-19 : 16:49:24

so what would be value in status field if db in suspect mode? thanks

Table: Sysdatabase
Field: Status
[/quote]

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-03-20 : 12:56:52

In BOL, go to sysdatabases, it'll show you all the values for all the fields on the table. I'm not 100% sure but I'm guessing the value would be 256 (not recovered).

Terry

maryxu
Starting Member

36 Posts

Posted - 2008-03-20 : 17:08:20

i check the status 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.

quote:
Originally posted by tosscrosby

In BOL, go to sysdatabases, it'll show you all the values for all the fields on the table. I'm not 100% sure but I'm guessing the value would be 256 (not recovered).

Terry

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-20 : 23:46:23

Did you refresh the display?

maryxu
Starting Member

36 Posts

Posted - 2008-03-24 : 15:22:45

yes, i did, still show "suspect", thanks

quote:
Originally posted by rmiao

Did you refresh the display?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-24 : 21:52:46

Can you access the db? What's sql edition and sp level?

maryxu
Starting Member

36 Posts

Posted - 2008-03-25 : 15:20:50

no, can't, it is 2000 SP3

quote:
Originally posted by rmiao

Can you access the db? What's sql edition and sp level?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-25 : 22:42:44

Looks like the db was suspect but someone reset status with sp_resetstatus. Did you see any error in sql server log and windows event logs? Do you have good backup?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources