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.