Thanks, I did that.

I ran dbcc chekcdb(dbname)....and looked at the error, I see an error 'An error occurred in the service broker manager, error:823, state 2.

I also see another error says 'The operating system returned error 21(the device is not ready.) to sql server during at offset 0x0000..........etc.

I know we can reset the status to recovery.....but I am more looking at what exactly the cause for this so, it won't happen again.

Thanks,

SueTons.