Database becomes suspect after reboot

[cocopud]

We have had our database become suspect, once with an unexpected system shutdown and again today when we rebooted the system.

Does anyone know why this happens and how to avoid it and also is there anyway to get the database back without restoring from tape and not losing todays changes?

 

[SQLSister]

Read about suspect keyword in Books online. You can change the status but only if the error logs showed that the reason the database became suspect was because of insuffience drive space available to recover the database and you fixed the problem. TAke heed of the warnings about doing this. If your database is corrupt it will not fix it. Since you indicate you are only doing nightly backups, I suspect this may be the case for you. Your transaction logs have probably grown to take up all your disk space. You need to revisit your backup process anyway, so that you are not losing a whole day's worth of data. You should run transaction log backups every hour or half hour. This will keep the tranascation logs small.