Home » More Information
SQL MDF Viewer – A Free Software to View Damaged MDF Contents
SQL MDF Viewer is the application meant genuinely to give access to corrupted data stored in MDF files created using SQL Server. It is purely shareware software created with sole purpose to let SQL user access contents in MDF files like tables, stored procedures, triggers, views etc.
It is important to know errors in MDF files of SQL Server. Some of the errors and causes for errors are listed below:
Error Messages After SQL Server Corruption.
Some of the error messages are given below with the causes:
- Msg 8914, Level 16, State 1, Line 1
Incorrect PFS free space information for page (1:26839) in object ID 181575685, index ID 1, partition ID 293374720802816, alloc unit ID 76911687695381 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
Cause For Error: The above-mentioned error clearly indicates that PFS page or page free space that tracks have incorrect values. The error occurs in SQL 2000 version.
- Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 181575685, index ID 1, partition ID 72057594145669120, alloc unit ID 72057594087800832 (type LOB data). The off-row data node at page (1:2444050), slot 0, text ID 901891555328 is not referenced.
Cause for Error: The reason for error above is LOB pages or Large Object, which are not referenced by any data row. Error also occurs because of clustered index corruption or also because of deallocate of corrupted page
- Msg 2570, Sev 16, State 3, Line 17
Page (1:1103587), slot 24 in object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type "In-row data"). Column "modified" value is out of range for data type "datetime". Update column to a legal value.
Cause for Error: The error indicates value in column, which is out of the range of column.
- Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=181575685) of row (object_id=181575685,column_id=1) in sys.columns does not have a matching row (object_id=181575685) in sys.objects.
Cause for Error: The cause for this error is SQL 2000 up gradation when someone directly update system tables
- Msg 8946, Level 16, State 12, Line 1
Table error: Allocation page (1:2264640) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.
- Msg 8998, Level 16, State 2, Line 1
Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 13 pages from (1:2264640) to (1:2272727)
Same Cause for both Errors: Both of the above-mentioned error messages have similar reason to arise. Both errors arise because of one or more database allocation pages, which are badly damaged. Allocation pages are badly damaged, these allocation pages are to mark extents and pages in the databases allocation
Corruption Cases in MDF Files: Listed Below are Reasons for Corruption in .mdf Files:
- Damaged or deleted.ldf Log file
- Data deletion like tables, stored procedures, views, records, etc
- Suspected mode of SQL database
- Input errors and output errors