Database in recovery mode - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Database in recovery mode

Author

Topic

rupesh.ravi
Starting Member

2 Posts

Posted - 2009-04-30 : 10:58:11

My SQL Server database marks the database to "in recovery" mode
when I am running an application that is doing a batch of insert and update transaction.
Is it abnormal, or is it a standard behavior.

DKG
Starting Member

3 Posts

Posted - 2009-04-30 : 11:05:19

Is everthing running all right with the database, means application is able to insert/update/select records from the database. Try to refresh the database - by right clicking on it. It should be normal - not shoing any recover mode etc.

rupesh.ravi
Starting Member

2 Posts

Posted - 2009-05-06 : 11:50:49

Yes, I don't see anything going wrong with transactions!
Its just that I was worried that what if the system never recovers and would I loose data

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-06 : 12:46:57

You should not be seeing it "in recovery" while the application is performing transactions to the database.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

hemantnehete
Starting Member

1 Post

Posted - 2009-11-04 : 07:22:00

In "In Recovery" mode.
Database is no more accesible from Application or user.
In short, We can't connect or perform any operation on database.

99% It will recover database.

HEMANt

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources