Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corruption of data
Message
De
23/11/2011 08:40:40
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01529561
Message ID:
01529661
Vues:
31
>What DBCC CHECKDB reported? Are you running it daily to catch corruption immediately?

When I run it in our development environment, I get:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'MyDatabase'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Those are the last two lines. Based on the first on the last two lines, if 0 allocation errors and 0 consistency errors have been found, it this the proper representation that everything is ok?

When I run it in our production environment, I get:

CHECKDB found 0 allocation errors and 4 consistency errors in database 'MyDatabase'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MyDatabase).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

...where I have this in one location:

Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:24979) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.

...and this in another location:

Msg 2533, Level 16, State 1, Line 1
Table error: page (1:24979) allocated to object ID 547533034, index ID 1, partition ID 72057594536198144, alloc unit ID 72057594561429504 (type In-row data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 547533034, index ID 1, partition ID 72057594536198144, alloc unit ID 72057594561429504 (type In-row data). Page (1:24979) was not seen in the scan although its parent (1:130354) and previous (1:120937) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 547533034, index ID 1, partition ID 72057594536198144, alloc unit ID 72057594561429504 (type In-row data). Page (1:151301) is missing a reference from previous page (1:24979). Possible chain linkage problem.
There are 400007 rows in 14570 pages for object "MyTable".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'MyTable' (object ID 547533034).

How do we fix that?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform