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

cathric

Open Question Bookmark and Share

What are the causes of Error9004?

When I was running a Restore Database with Recovery statement in order to bring a standby server online then an Error 9004 has occurred. Can anyone help me resolve the Error?

275 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)

cathee 		Generally the Error 9004 occurs because of the physical characteristics (virtual log parity) that are especially for the inactive virtual log files that is in the transaction log that are not preserved when the full database backup has been restored. This problem can be resolved with the help of MS SQL Database recovery. The MS SQL Database recovery provides powerful algorithm that performs a complete and thorough scan of the SQL files so that the error can be resolved without deleting or modifying the original data structure. The software is ideal in recovering the error that has caused because of the malfunctioning of any of the components of the SQL server database. So for resolving this problem you will have to obtain the latest version of the service pack for Microsoft SQL Server 2000, there you can view the article and act accordingly then this problem can be resolved.

Posted 275 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