[AccessD] SQL Server - (In Recovery)

I love the recovery ability. QA (SQL 2000) didn't have that ability.

Its similar to Word's recovery if your computer lost power and you open up
Word, your last document is available as a "recovery".

This happened to me the other night while I was VPN'd to my work computer.
I was pulling an all nighter, couldn't keep my eyes open after 3AM so I went
to bed (without saving).

Came in to work and noticed my computer had reboot (I had left all of my
files open).

I was so pissed! then when I opened SS Management Studio, it opened all of
my tabs as recovered files.

In the words of Jeff Spicoli "That was totally awesome!" :)

On Wed, Aug 19, 2009 at 10:09 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> Hi, I'm SqlServer and I am addicted to cpu cycles, memory and disk space...
>
> John W. Colby
> www.ColbyConsulting.com <http://www.colbyconsulting.com/>
>
>
>  Charlotte Foust wrote:
> > It means the database has joined a 12-step program ... Sorry, I couldn't
> > resist!
> >
> > Charlotte
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> > Sent: Wednesday, August 19, 2009 9:28 AM
> > To: Dba-Sqlserver; Access Developers discussion and problem solving
> > Subject: [AccessD] SQL Server - (In Recovery)
> >
> > What does (in recovery) mean when next to a database name in the
> > management studio.
> >
> > I have two databases that show (in recovery).  One if them I was
> > actually working in, the other I wasn't.
> >
> > I am not finding anything on Google that explains what it means.
> > --
> > John W. Colby
> > www.ColbyConsulting.com <http://www.colbyconsulting.com/>
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>