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

freidadcosta

Open Question Bookmark and Share

Facing Error 896 in SQL Server 2003 ?

For the past 3 days or so, I am getting a very peculiar kind of error message on my SQL Server 2003. The moment I try to access any of the MDF files, I am getting a very big error message popping up in front of my screen like this:

Server: Msg 8906, Level 16, State 1, Line 0 Page P_ID in database ID DB_ID is allocated in the SGAM SGAM_P_ID and PFS PFS_P_ID, but was not allocated in any IAM. PFS flags 'PFS_FLAGS'.

There are some very important files on the server which I need to access them any how and I need suggestions from the people how to proceed ahead.

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

The aforesaid error is also called as Error 8906 occurs when a page of ‘mixed page’ bit has not been able to get detected in the PFS byte as well as in the IAM. This further leads to corruption in the database and hence you get the aforesaid error message. The first thing that needs to be done is that you will have to fix any kind of hardware problems if there in the system by running the hardware diagnostics. Try to restore the data from previous backup and if there is no backup available, then run the DBCC CHECKDB command that would certainly fix the issue.

If still the error message does not goes away and continues to cause irritation to you, then opt for SQL Database Recovery tool that would repair and recover all the corruption in the database using sophisticated algorithm and programming methods. Download it from the internet and use it on your system and I am quite sure that things would work for you.

All the Best…..


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