June 16, 2008 at 2:44 pm
Right now, There is a recovery process going on. Is there a fastest way to get the database back without restoring from a backup. Can I stop the recovery process. ?
June 16, 2008 at 3:09 pm
No. recovery must finish to ensure that logs are re-played.
* Noel
June 16, 2008 at 3:17 pm
Does the recovery process fills the transaction log. ?
and also is there a gurantee that database will be in a perfect shape. the reason I am asking if we stop the recover process and start doing tape restore then it will take 39 hours to complete the full database restore and I don't want to do that.
Right now recovery process is saying that
Recovery of database ABC(8) is 49% completed ( approximately 30197 more seconds) phase 3 of 3
What does (8) stand for and what is phase 3 of 3.
how do you calculate how long recover process will take.
June 16, 2008 at 3:26 pm
balbirsinghsodhi (6/16/2008)
Does the recovery process fills the transaction log. ?and also is there a gurantee that database will be in a perfect shape. the reason I am asking if we stop the recover process and start doing tape restore then it will take 39 hours to complete the full database restore and I don't want to do that.
Right now recovery process is saying that
Recovery of database ABC(8) is 49% completed ( approximately 30197 more seconds) phase 3 of 3
What does (8) stand for and what is phase 3 of 3.
how do you calculate how long recover process will take.
I have seen these messages when there is hardware stress. Are you sure your disks can keep up?
You could stop it and recovery will start from the begining the numbers you posted seem excessive. The only thing I think you can do to stop this is : killing the instance but I don't remember what exactly I did because recovery only works as a system spid which you cannot kill.
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply