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-12-04 : 08:10:12
|
| sumedh writes "Dear sir,I use SQL7.0 and many times my database not open, give msg me that Database is suspect.if this msg occure no other choice to me than restore backup again so What is a database suspect? what i do when database suspect? please give me answer.thanks." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-04 : 11:02:40
|
| If this keeps happening for no apparent reason you probably have a hardware problem. Run some diagnostics on the disk. Are you getting any errors in the nt event log?Are you doing anything dubious? Running out of space, detach/attach, large imports,...Does it happen after maintenance operations?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-12-04 : 11:16:34
|
| Possible causes are databases files not found, no space in the Disk, db corruption.Check sql error log and windows event log for details.Check if some programs, maybe third party backup tools, or even the OS, has control on disks and maybe also exclusive access to them in some particular time (when you startup your server)....and please have a look at BOL under "suspect", you will find very interesting arguments.Don't forget to search on this forum how to reset the status of a suspect db.Good luck.Franco |
|
|
|
|
|
|
Database suspect