Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The log for database is not available; Database was shutdown due to error 9001 in routine...


The log for database is not available; Database was shutdown due to error 9001 in routine 'XdesRMFull::Commit'.

Author
Message
Jatin Soni
Jatin Soni
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 371
Hi,
I just got the same error on one of my database and would like to share how I recovered from it.

Troubleshooted by following
(1)Take database offline
(2) bring database online
(3) change the database property to Auto Close = False
(4) we need to run dbcc so we will require db in single mode. change the database property to single user mode.
(5) run below dbcc command
dbcc checkdb ('db', REPAIR_REBUILD)
(6) now it should run fine and above log related error should not appear.
(7) change database property to “Multi User mode”

Note that we run dbcc every weekly and this error was not appeared at that time. I also have plenty of free disk space so I am still not clear why error appeared.

In my case above method worked. If there is any better way to troubleshoot this, then let me know.

Can someone let me know why this error appears? I mean what causes this ?
Oliiii
Oliiii
SSC Veteran
SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)

Group: General Forum Members
Points: 212 Visits: 777
"Device not ready" usually means the server lost a disk (if your disk is a SAN device), check with your SAN admin to see what happened.
You can confirm it by looking in the windows system event log, you should see messages from the SAN vendor driver (i.e. EMC drivers complaining a path/port/device just died).

Once you get your disk back (after a few seconds or after intervention) you can try:
ALTER DATABASE [MyDB] SET ONLINE



If that fail, the error log will give you more info on what's going on.
forsqlserver
forsqlserver
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1222 Visits: 2045
We have also received Alert: The log for database is not available Resolution state: New

from SCOM

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search