SQLCrazyCertified (1/8/2013)
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.
The operating system returned error 21(the device is not ready.)
This message is an operating system error. It is more of a generic message letting you know there is an issue with the disk subsystem. It can be caused by a number of things such as:
LUNS not being available for the OS
the SAN was unplugged
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events