Groups > comp.databases.ms-sqlserver > #221

How can I check out the reason a db is in recovery?

From	mat <mat@notarealdotcom.adr>
Newsgroups	comp.databases.ms-sqlserver
Subject	How can I check out the reason a db is in recovery?
Date	2011-04-26 07:39 -0700
Organization	A noiseless patient Spider
Message-ID	<MPG.282078f3ff2f46da989687@news.eternal-september.org> (permalink)

Show all headers | View raw

This AM a database on my dev box is listed as being in recovery. I 
checked the sql server log (in SSMS Management/SQL Server Logs) and all 
it says is that there was a serious error. This db was not used for a 
couple of days and the machine didn't crash or anything like that so I'm 
disturbed that 'somehow' it became broken and I'd like to explore why.

The log I've seen so far just says 

Error: 18456, Severity: 14, State: 38.

I can stop the db engine and delete/restore no problem (is a dev copy, 
not production) but I'd rather see what else I might be able to learn 
from this. What else can I check?

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

How can I check out the reason a db is in recovery? mat <mat@notarealdotcom.adr> - 2011-04-26 07:39 -0700
  Re: How can I check out the reason a db is in recovery? Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-26 17:31 +0200
  Re: How can I check out the reason a db is in recovery? Erland Sommarskog <esquel@sommarskog.se> - 2011-04-26 22:45 +0200
    Re: How can I check out the reason a db is in recovery? mat <mat@notarealdotcom.adr> - 2011-04-27 08:34 -0700
      Re: How can I check out the reason a db is in recovery? Erland Sommarskog <esquel@sommarskog.se> - 2011-04-27 23:58 +0200
        Re: How can I check out the reason a db is in recovery? mat <mat@notarealdotcom.adr> - 2011-04-28 08:44 -0700
          Re: How can I check out the reason a db is in recovery? Erland Sommarskog <esquel@sommarskog.se> - 2011-04-28 23:58 +0200
            Re: How can I check out the reason a db is in recovery? Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-29 08:05 +0200
          Re: How can I check out the reason a db is in recovery? Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-29 07:59 +0200

csiph-web