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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-17 : 07:29:06
|
| steve writes "Hi,My hard drive developed a fault overnight and this morning when I load the Enterprise Manager I cannot open my database as it is now 'suspect'. When I try a DBBC checkdb on it I get the following errorDatabase 'MIS' cannot be opened because some of the files could not be activated.Is there any way to fix this error or do I have to start again from scratch?" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-10-17 : 08:05:00
|
| have you tried sp_resetstatus??- Sekar |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-17 : 12:30:48
|
| Yes run sp_resetstatus as samsekar mentioned. You then should run DBCC CHECKDB again to see if there are any consistency errors. You should also try to figure out what caused the database to go suspect. Take a look in the Event Log to see if there are any hardware problems. Also, check SQL Server's Error Log.Tara |
|
|
|
|
|
|
damaged sqlserver databse