Bonjour,

Tous les soirs, se lance sur notre base
use master
go

dbcc checkstorage(nom_base)
go

dbcc checkverify (nom_base)
go
Depuis deux semaines, tous les mardis soir j'obtiens
Checking nom_base
Storage checks for 'nom_base' are complete. DBCC is now recording the results
in the dbccdb database.
DBCC CHECKSTORAGE for database 'nom_base' sequence 2056 completed at Jan 19
2011 5:43AM. 0 faults and 117 suspect conditions were located. 1 checks were
aborted. You should investigate the recorded faults, and plan a course of action
that will correct them.
Suspect conditions are to be treated as faults if the same suspect condition
persists in subsequent CHECKSTORAGE operations, or if they are also detected by
other DBCC functions.
Verifying faults for 'nom_base'.
DBCC CHECKVERIFY for database 'nom_base' sequence 2056 completed at Jan 19 2011
5:43AM. 84 suspect conditions were resolved as faults, and 33 suspect
conditions were resolved as harmless. 0 objects could not be checked.
(1 row affected)
Deleting results of DBCC operations completed on or before Jan 4 2011 5:42AM
on the database nom_base.
(return status = 0)
Ce qui m'intrigue c'est le check aborted. Le lendemain, pas de check aborted.

J'aimerais identifié quel check a été avorté. Mais après diverses recherches sur mes docs et internet dont ici, je sèche.

Pourriez-vous svp m'indiquer comment procéder ?

De base, je me dis qu'il n'y pas péril en demeure mais je n'aime pas savoir
D'autant je découvre le sujet.

Merci.

Un développeur débutant la DBA