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.
| Author |
Topic |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2007-12-04 : 17:48:05
|
| Hi!I am having a problem with one of my local data bases, it shown the status of (suspect).When I try to apply solutions that I found on internet for example run:sp_resetstatus 'dbImpOfertas' it shows the message that : The databse 'dbImpOfertas' does not exist.Use sp_help to show available databases. This is the log information:2007-11-28 00:00:03.68 spid53 Starting up database 'bdImpOfertas'.2007-11-28 00:00:03.76 spid53 Error: 602, Severity: 21, State: 502007-11-28 00:00:03.76 spid53 Could not find row in sysindexes for database ID 15, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes..2007-11-28 00:00:05.21 spid53 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_instance_regread'.2007-11-28 00:00:05.21 spid54 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_instance_regread'. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-04 : 22:33:03
|
| Did you see any disk related error in windows event log? |
 |
|
|
|
|
|
DB suspect not show in sp_help