Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | View raw

mat (mat@notarealdotcom.adr) writes:
> 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.

So there is a stack dump in the log? The stack dump is not entirely
easy to read, but usually there is some indication of the statement
that was issued. Also, the date and time for the accident may give 
some indication.

Maybe you have a maintenance job set up and something went wrong during 
this job. Why something would go wrong all of a sudden? Bad hardware is
a common reason.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | 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