Search for questions :
My Profile
Categories

AvinashKumar

Open Question Bookmark and Share

How to fix “Page Error” in SQL Server?

On last night when I tried to access a page from SQL Server database, the system replied me an error message as “Page error” and finally the database table including that file become inaccessible. So I came here for help. If anyone who have the solution for my issue, I request you please reply me. That file has many important data and information so any how I wan to get back that file.

Thanks!

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

JimmyRayJit 		SQL Server file contains many critical files and pages that stores it allocation structure. The related information to this allocated extents are saved in GAM (Global Allocation Page). While, each and every allocation page who contains all related info to the extents are stored in an index or table named as IMA (Index Allocation Map). If many Index Allocation Map forms for a single object, error messages might be encounter as “Page Error”.

Those error messages are the flat sign of tale corruption. In such situation you need restore your SQL database using current backup. Unluckily if you have no backup or backup have insufficient data, then you are recommended for MDF Repair tools. Today many professional and powerful MDF Repair tools are available and designed for safe repair and recovery. You can choose any one and resolve your issue right now!


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