New User ? Sign Up  |  Sign In  |  Help
ask
answer
discover
     
Search for questions :
My Profile
Categories

richmond

Open Question Bookmark and Share

The Database restore operation has failed during the recovery phase, what is the reason for this and how to fix this problem?

I was performing the back up of the database as such I have a database in that the query notification has been enabled in the Microsoft SQL Server 2005 in that I was trying to restore the database from this backup, then the restore operation has failed during the recovery phase. How should I fix this problem?

830 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

clodiya 		This problem has caused because of the query notification has been sent to a user who has been dropped from the database before the database has been backed up. And when you restore the database, then the SQL server tries to redo all the query notification transaction as the part of the database startup. Although the processing of the query notification fails because the user does not exist and then 9768 error is raised and this error is not correctly handled by SQL server and the severity of the error increases. This causes for the recovery of the recovery transaction to fail and finally the restore operation also fails. This problem can be resolved with the help of SQL Database recovery, at first you will have to release the Cumulative update 6 for SQL Server 2005 Service Pack 3. The MS SQL Database recovery provides powerful algorithm that performs a complete and thorough scan of the SQL files so that the data can be retrieved without deleting or modifying the original data structure.

Posted 830 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0