|
|
|
 SQL - Teknisk info Fejlene vil typisk vise sig på forskellige måder ofte i Windows Eventlog. Vi har forsøgt at samle en del teknisk information om kendte fejlbeskeder og tilhørende årsager.
Windows eventloggen og T-SQL Query:
The total number of data pages in this table is 2024. Server: Msg 7930, Level 16, State 1, Line 1 Table Corrupt: keys in left child is not less than the parent key; check left child page 850104. Table has 12026 data rows.
Server: Msg 605, Level 21, State 1, Line 1 Attempt to fetch logical page 572561 in database 'DB' belongs to object '0', not to object 'sds'.
Database 'DB' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
..........................................................................................
Server: Msg 8906, Level 16, State 1, Line 1 Page (1:53) in database ID 5 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'
..........................................................................................
Server: Msg 2533, Level 16, State 1, Line 1 Table error: Page (82:53) allocated to object ID 6, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
..........................................................................................
Server: Msg 8948, Level 16, State 1, Line 1 Database error: Page (82:53) is marked with the wrong type in PFS page (82:1). PFS status 0x0 expected 0x60.
..........................................................................................
Server: Msg 8980, Level 16, State 1, Line 1 Table error: Object ID 6, index ID 1. Index node page (1:51), slot 0 refers to child page (1:53) and previous child (0:0), but they were not encountered.
..........................................................................................
Server: Msg 8978, Level 16, State 1, Line 1 Table error: Object ID 6, index ID 1. Page (1:59) is missing a reference from previous page (1:53). Possible chain linkage problem.
..........................................................................................
Server: Msg 8951, Level 16, State 1, Line 1 Table error: Table 'sysfilegroups' (ID 96). Missing or invalid key in index 'sysfilegroupsnc' (ID 2) for the row:
..........................................................................................
Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:48:0) identified by (RID = (1:48:0) groupid = 1) has index values (groupname = 'PRIMARY' and groupid = 1).
..........................................................................................
Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'pubs', index 'sysfilegroups.sysfilegroupsnc' (ID 96) (index ID 2). Extra or invalid key for the keys:
..........................................................................................
Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:49:0) with values (groupname = 'PRIMARY' and groupid = 1) points to the data row identified by ().
..........................................................................................
CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysfilegroups'
|