Database (In Recovery)

Hi all

When I restart server my database apear as database(In recovery )

what's ?

thanks

may be some huge bulk insert operations might be operational in your db @. the time of restart hence they will be rolling forward the commited transactions........and rolling back the uncommitted transactions.....

just type the following command to bring your db into normal mode

restore database dbname with recovery

|||When the SQLSERVER.exe service is started; as a part of recovery steps it attempts to recover the database. Check the size of transaction log of this database , as it might have many transactions that needs to go through REDO / UNDO phase. Give it some time and database should be online. You could run xp_readerrorlog to see estimated time it may require for Analysis phase etc.

Hope this helps

Vishal|||

The log will show you the correct error message if the database cannot be recovered finally. In the meantime, you will have to wait until the process of instant recovery is finished.

Jens K. Suessmeyer.

http://www.sqlserver2005.de