Database Recovering Question

Hi
I sometimes see '(Recovering)' written next to one of the sql server
databases. Can anybody please explain on why does that happen and also if
there is any problem with my databases?
TIA
VaibhavViabhav,
If you see these during startup it means that the tranaction log is still
being applied to the database in question.
When the (Recovering) goes away, the recovery is complete. If it is taking
significant time it suggests that the SQL Server was not shutdown cleanly
and that quite a bit of log activity must be processed.
If (Recovering) does not go away, then you have a problem. Otherwise, all
is fine.
Russell Fields
http://www.sqlpass.org/
2004 PASS Community Summit - Orlando
- The largest user-event dedicated to SQL Server!
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:Ogv$GdEsDHA.2380@.TK2MSFTNGP09.phx.gbl...
> Hi
> I sometimes see '(Recovering)' written next to one of the sql server
> databases. Can anybody please explain on why does that happen and also if
> there is any problem with my databases?
> TIA
> Vaibhav
>