Wednesday, August 15, 2012 7:15 PM
Today After cancel a query that warm my DB server that message come up on one of my database.
what are the steps to follow in this case?
If after a while the database still have this status, what I need to do?
Thanks you for your time
- Changed Type Samuel Lester - MSFTMicrosoft Employee, Moderator Wednesday, August 15, 2012 7:41 PM
Wednesday, August 15, 2012 8:15 PMhave a look in the error log. it should tell you how long's left to go. what does sys.databases say the status to be?
Thursday, August 16, 2012 5:20 AM
restore database dbaname with recovery
buy check the SQL Server Errors by using xp_readerrorlog in SQL Server Management Studio
Ramesh Babu Vavilla MCTS,MSBI
- Proposed As Answer by vr.babu Friday, August 17, 2012 5:38 AM
Thursday, August 16, 2012 1:57 PMcheck sql server errors log for more details & share the same.
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
Thursday, August 16, 2012 8:47 PM
something that has caused to relfect the Database in to recovery mode may be something might be issue when performin some query against the database abnormalities of power failure or improper shutdown and made the database to inrecovery or it might be the transaction log file performing its undo part to ensure the interity of the database...
so one thing you can resolve check the DMV called sys.dm_exec_requests(incase of SQL 2005+) to check the recovery status...(alsois that Mannually some one issues the restored activityon the DB)...... and if you see progress(seepercentage column or estimated....column) then wait for the DB to get it recovery...
or you can just restore with the well good backup if you feel so once you have anyalzed what caused the issue to reflect the DB to recovery status by going through the event logs and SQL error logs..
Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, August 23, 2012 8:21 PM