[AccessD] SQL Server - (In Recovery)

Sounds like something became 'corrupt', and it's going back through the
transaction logs to make sure everything is ok.

Of course, it may have picked up a few bad habits, as Charlotte
mentioned...are you using natural or surrogate keys?  Natural keys would
be sure to make any server side db take up the bottle.... ;)

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, August 19, 2009 11: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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.