alexandert680@gmail.com1/9/2013)[/b]

---

Post the exact errors from the SQL error log (all of them), then switch the DB into Emergency mode and run

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

and post those errors

You can't just reset the status on a suspect DB to normal. Suspect means damaged, has to be restored (prefered) or repaired (if there's no backup)

If it's just the error 21, then a restart of SQL might fix it, and then you need to identify why the disks are disappearing underneath SQL.[/quote]

One of my colleague reboot the server and it solved the issue. Anyway, I had contacted the windows/storage team to investigate further.

Thanks for all your valuable inputs.

SueTons.