Database file has a bad block repair process

zhaozj2021-02-16  138

A few days ago, the database file has a problem, and the phenomenon is that some query operations will report the following errors:

Microsoft OLE DB Provider for SQL Server Error '80004005' Warning: Fatal Error 644 Occurred At Aug 5 2004 8:45 AM

or:

Microsoft OLE DB Provider for SQL Server Error '80004005' Warning: Fatal Error 823 Occurred At Aug 4 2004 10:39 PM

823 Error means that SQL Server encounters I / O errors when reading or writing a request for a device. This error usually shows disk

problem.

644 Error refers to: This error occurs when the index ID represents the non-aggregated index. This corruption is detected when the process attempts to delete the unsausty.

The hard disk of that database server is to do RAID 5, query the specific hard drive, and did not see the hard drive. Back up the data and return to another machine. There is still this problem. Obviously the database file has a bad block.

Try to fix the database by the following statement, but only some data can be repaired, but it cannot be completely fixed.

DBCC Checktable ('Data Table') DBCC CheckTable ('Data Table') with all_errormsgsdbcc checktable (data table, repair_allow_data_loss)

DBCC DBREINDEX ('Data Table ")

Sp_dboption 'Database Name', 'Single User', Truedbcc Checkdb ('Database Name, Repair_Allow_Data_loss) sp_dboption' Database Name ',' Single User ', False

The import function with SQL Server cannot export data. The 823 error will be reported. The select of all data will also report 823 errors.

Below is some representative error messages returned after returning by these fixing statements:

Server: MSG 8929, Level 16, State 1, Line 1 Object ID 797245895: An error is found in text ID 4582550994944, the owner of this text is data recorded by RID = (1: 65204: 25) replyid = 22853478.

Server: MSG 8909, Level 16, State 1, Line 1 error: Object ID 0, Index ID 13824, Page ID (1: 430153). PageID = (31744: 9744137) page.

Server: MSG 2533, Level 16, State 1, Line 1 Table Error: Unconscent page (1: 307388), the page assigned to the object ID 397244470, index ID 0. Possible page invalid or page The object ID information in the page is incorrect.

Server: MSG 8978, Level 16, State 1, Line 1 error: Object ID 397244470, Index ID 1. Page (1: 307360) lacks the previous page (1: 307391) to its reference. It may be because there is a problem with the link of the chain.

Server: MSG 8976, Level 16, State 1, Line 1 error: Object ID 397244470, Index ID 1. No page (1: 307388) in the scan operation, while its parent (1: 308098) and the previous page (1: 307387) point to the page. Please check the previous error.

Server: MSG 8980, Level 16, State 1, Line 1 error: Object ID 397244470, Index ID 1. Index node (1: 308098), slot 155 points to sub-page (1: 307389) and previous subpages (1: 307388), but not encountered.

Server: MSG 8939, Level 16, State 1, Line 1 Table Error: Object ID 825360384, Index ID 62467, Page (1: 430152). Test (m_slotcnt

Server: MSG 8986, Level 16, State 1, Line 1 is found (201) too many (belonging to Object ID 797245895). To view all error messages, re-run the statement with 'with all_errorssgs'.

Server: MSG 8964, Level 16, State 1, Line 1Table Error: Object ID 797245895. The text, ntext, or image node at page (1: 90548), slot 53, text id 4297096364032 is not reasoned.

Server: Msg 8974, Level 16, State 1, Line 1Text node referenced by more than one node Object ID 797245895, text, ntext, or image node page. (1: 100941), slot 15, text ID 4367996551168 is pointed to by page (1: 407572), Slot 25 and by page (1: 430169), Slot 25.

Server: MSG 8961, Level 16, State 1, Line 1Table Error: Object ID 797245895. TEXT, NTEXT, or Image Node At Page (1: 100944), Slot 29, Text ID 4582550732800 Does Not Match ITS Reference from Page (1 : 430166), Slot 55.

Server: MSG 8965, Level 16, State 1, Line 1Table Error: Object ID 797245895. The text, ntext, or image node at page (1: 307381), slot 4, text id 4584554954752 is reference by page (1: 3786) , Slot 75, But Was Not Seeen in the scan.

转载请注明原文地址:https://www.9cbs.com/read-7796.html

New Post(0)