Search

Friday, January 7, 2011

Recovering SQL database to solve Error 8928 in MS SQL Server 2000 database

Database pages in an MS SQL Server database are that basic unit of storage, which store the information in the records. These pages consist of eight bytes and eight contiguous pages constitute an extent. At times, these pages do get corrupt thereby disabling you to read through the pages. Such scenarios appear because of various MDF file corruption reasons such as virus infections, hardware damage, abrupt system shutdown when the database is open, etc. The possible way-out is to look for the reason of such errors and solve the problem. If you are unable to look for a working solution, then you should use a third-party SQL database recovery software to perform MDF recovery.

Consider a situation in which you are receiving the following error message when you are working on an MS SQL Server 2000 database:

“Object ID O_ID, index ID I_ID: Page P_ID could not be processed. See other errors for details.”

Cause:

Such problem may cause if some problems are encountered in the page definitions.

In this case, a P_ID page is marked as allocated in a PFS (Page Free Space) page. However, this page is unable to read.

Resolution:

To resolve this problem, you are advised to use different methods to perform SQL recovery. This could be done by performing the following methods:

  • Resolving the hardware related issues: It has been observed that mostly such errors arise due to failed hardware parts. This problem can be resolved using the following measures:

◦ Fix the errors that appear after running hardware diagnostics.

◦ Repair the hardware-related errors that are displayed in the Error logs, if any.

◦ Checking if write-caching is enabled for the hard disks. If yes, then contact the local hardware vendor for the appropriate solution.

◦ Swapping the hardware parts to isolate the exact cause of error.

◦ Installing the operating system after formatting the hard drives.

  • Using the database backup: You should check the database backup and use it to restore the database, if it is clean and updated.
  • Executing DBCC CHECKDB: You should run the DBCC CHECKDB tool using the suggested repair clause, if the issue is not solved using the previous method.

If the problem is persisting even after performing the aforementioned MDF file recovery methods, then I would recommend you to take the services of a third-party MS SQL Server recovery software. With the use of highly sophisticated scanning algorithms, these master database file recovery software ensure that the database recovery is safe and secure.


No comments:

Post a Comment