Discussion :

[Julce]

Bonjour,

j'ai un problème d'E/S sur mon SQL Server 2000. En analysant les logs, j'ai eu dans un premier temps l'erreur suivante :

18272 :
I/O error on backup or restore restart-checkpoint
file 'C:\Program Files\Microsoft SQL Server\MSSQL\backup\master4IDR.ckp'.
Operating system error 3(error not found).
The statement is proceeding but is non-restartable.

Puis j'ai en permanence l'erreur :

Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x00000005346000
in file 'd:\database\dbnorten'.


Si j'efface ma base, que je la recréée et que j'y importe mes données sauvegardées, le problème disparait mais réapparait les jours suivants.

Je ne suis pas un expert, quelqu'un aurait-il une idée ?



Merci

[Julce]

Voici le résultat de la commande dbcc checkdb <nom_de_ma_base> :

DBCC results for 'hulpnorthen'.
DBCC results for 'sysobjects'.
There are 2531 rows in 59 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 672 rows in 32 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 11346 rows in 174 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 2249 rows in 875 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 1300 rows in 5 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 27 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 21587 rows in 118 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 266 rows in 2 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'tbl stock zone truck'.
There are 0 rows in 0 pages for object 'tbl stock zone truck'.
DBCC results for 'tbl operator'.
There are 14 rows in 1 pages for object 'tbl operator'.
DBCC results for 'tbl wagontype'.
There are 51 rows in 4 pages for object 'tbl wagontype'.
DBCC results for 'tbl recieve offre supplier'.
There are 0 rows in 0 pages for object 'tbl recieve offre supplier'.
DBCC results for 'tbl cim net'.
There are 35 rows in 1 pages for object 'tbl cim net'.
DBCC results for 'MSmerge_errorlineage'.
There are 0 rows in 0 pages for object 'MSmerge_errorlineage'.
DBCC results for 'tbl stock cross header'.
There are 0 rows in 0 pages for object 'tbl stock cross header'.
DBCC results for 'MSrepl_identity_range'.
There are 0 rows in 0 pages for object 'MSrepl_identity_range'.
DBCC results for 'tbl incoterm'.
There are 2 rows in 1 pages for object 'tbl incoterm'.
DBCC results for 'tbl trpu blokkering'.
There are 0 rows in 0 pages for object 'tbl trpu blokkering'.
DBCC results for 'tbl internetuser logging'.
There are 149 rows in 1 pages for object 'tbl internetuser logging'.
DBCC results for 'sysmergearticles'.
There are 178 rows in 14 pages for object 'sysmergearticles'.
DBCC results for 'tbl stock barcode'.
There are 67923 rows in 657 pages for object 'tbl stock barcode'.
DBCC results for 'tbl comp intu'.
There are 22 rows in 1 pages for object 'tbl comp intu'.
DBCC results for 'tbl stock warehouse'.
There are 4 rows in 1 pages for object 'tbl stock warehouse'.
DBCC results for 'tbl model purchase'.
There are 306 rows in 4 pages for object 'tbl model purchase'.
DBCC results for 'tbl vat purchase'.
There are 5 rows in 1 pages for object 'tbl vat purchase'.
DBCC results for 'tbl prices sales'.
There are 1915 rows in 72 pages for object 'tbl prices sales'.
DBCC results for 'tbl cim locatie sub'.
There are 1216 rows in 15 pages for object 'tbl cim locatie sub'.
DBCC results for 'tbl stock carist'.
There are 7 rows in 1 pages for object 'tbl stock carist'.
DBCC results for 'tbl goods'.
There are 25 rows in 2 pages for object 'tbl goods'.
DBCC results for 'tbl transportunit suivi delete'.
There are 0 rows in 0 pages for object 'tbl transportunit suivi delete'.
DBCC results for 'tbl formula'.
There are 53 rows in 1 pages for object 'tbl formula'.
DBCC results for 'tbl stock unit status'.
There are 0 rows in 0 pages for object 'tbl stock unit status'.
DBCC results for 'tbl cim reisweg frontiere'.
There are 927 rows in 6 pages for object 'tbl cim reisweg frontiere'.
DBCC results for 'sysmergeschemaarticles'.
There are 214 rows in 6 pages for object 'sysmergeschemaarticles'.
DBCC results for 'tbl stock goods arrived'.
There are 687 rows in 7 pages for object 'tbl stock goods arrived'.
DBCC results for 'sysmergesubscriptions'.
There are 2 rows in 1 pages for object 'sysmergesubscriptions'.
DBCC results for 'tbl invoice sale difference'.
There are 4 rows in 1 pages for object 'tbl invoice sale difference'.
DBCC results for 'tbl transportstatus'.
There are 4 rows in 1 pages for object 'tbl transportstatus'.
DBCC results for 'tbl prices purchase'.
There are 472 rows in 18 pages for object 'tbl prices purchase'.
DBCC results for 'tbl cim frontiere'.
There are 122 rows in 2 pages for object 'tbl cim frontiere'.
DBCC results for 'tbl resul header'.
There are 18 rows in 1 pages for object 'tbl resul header'.
DBCC results for 'tbl follow up events'.
Server: Msg 8928, Level 16, State 1, Line 2
Object ID 834570507, index ID 255: Page (1:10659) could not be processed. See other errors for details.
Server: Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 1162078812, index ID 226, page ID (1:10659). The PageId in the page header = (11683:1102406507).
There are 21 rows in 1 pages for object 'tbl follow up events'.
DBCC results for 'tbl transportunit suivi'.
There are 0 rows in 0 pages for object 'tbl transportunit suivi'.
DBCC results for 'tbl customer'.
There are 9 rows in 1 pages for object 'tbl customer'.
DBCC results for 'MSmerge_replinfo'.
There are 2 rows in 1 pages for object 'MSmerge_replinfo'.
DBCC results for 'tbl stock stod suni'.
There are 0 rows in 0 pages for object 'tbl stock stod suni'.
DBCC results for 'tbl aviscomp'.
There are 0 rows in 0 pages for object 'tbl aviscomp'.
DBCC results for 'MSmerge_tombstone'.
There are 17358 rows in 276 pages for object 'MSmerge_tombstone'.
DBCC results for 'tbl phonPers'.
There are 8143 rows in 136 pages for object 'tbl phonPers'.
DBCC results for 'MSmerge_contents'.
There are 26689 rows in 1191 pages for object 'MSmerge_contents'.
DBCC results for 'MSmerge_genhistory'.
There are 7416 rows in 152 pages for object 'MSmerge_genhistory'.
DBCC results for 'tbl invoice buy difference'.
There are 40 rows in 1 pages for object 'tbl invoice buy difference'.
DBCC results for 'tbl train status'.
There are 4 rows in 1 pages for object 'tbl train status'.
DBCC results for 'MSmerge_delete_conflicts'.
There are 0 rows in 0 pages for object 'MSmerge_delete_conflicts'.
DBCC results for 'tbl prices contract'.
There are 0 rows in 0 pages for object 'tbl prices contract'.
DBCC results for 'tbl cim code bijlage'.
There are 32 rows in 1 pages for object 'tbl cim code bijlage'.
DBCC results for 'tbl recordnumbers'.
There are 2250 rows in 15 pages for object 'tbl recordnumbers'.
DBCC results for 'sysmergeschemachange'.
There are 941 rows in 42 pages for object 'sysmergeschemachange'.
DBCC results for 'tbl elevateur'.
There are 0 rows in 0 pages for object 'tbl elevateur'.
DBCC results for 'tbl stock sprp srar'.
There are 846 rows in 6 pages for object 'tbl stock sprp srar'.
DBCC results for 'tbl contact'.
There are 2 rows in 1 pages for object 'tbl contact'.
DBCC results for 'sysmergesubsetfilters'.
There are 0 rows in 0 pages for object 'sysmergesubsetfilters'.
DBCC results for 'MSdynamicsnapshotviews'.
There are 0 rows in 0 pages for object 'MSdynamicsnapshotviews'.
DBCC results for 'tbl stock sprp suni'.
There are 10529 rows in 53 pages for object 'tbl stock sprp suni'.
DBCC results for 'tbl stock instruction input'.
There are 5 rows in 1 pages for object 'tbl stock instruction input'.
DBCC results for 'tbl link phoncomp'.
There are 3593 rows in 17 pages for object 'tbl link phoncomp'.
DBCC results for 'MSdynamicsnapshotjobs'.
There are 0 rows in 0 pages for object 'MSdynamicsnapshotjobs'.
DBCC results for 'tbl contract'.
There are 0 rows in 0 pages for object 'tbl contract'.
DBCC results for 'tbl title'.
There are 19 rows in 1 pages for object 'tbl title'.
DBCC results for 'MSmerge_altsyncpartners'.
There are 0 rows in 0 pages for object 'MSmerge_altsyncpartners'.
DBCC results for 'tbl reason block'.
There are 0 rows in 0 pages for object 'tbl reason block'.
DBCC results for 'tbl stock ref art'.
There are 1422 rows in 9 pages for object 'tbl stock ref art'.
DBCC results for 'tbl bobinestand'.
There are 12 rows in 1 pages for object 'tbl bobinestand'.
DBCC results for 'tbl database'.
There are 0 rows in 0 pages for object 'tbl database'.
DBCC results for 'tbl stock sprp sods'.
There are 673 rows in 4 pages for object 'tbl stock sprp sods'.
DBCC results for 'tbl consumer'.
There are 174 rows in 1 pages for object 'tbl consumer'.
DBCC results for 'tbl stock dossier millcode'.
There are 10 rows in 1 pages for object 'tbl stock dossier millcode'.
DBCC results for 'tbl_trpu_srar'.
There are 0 rows in 0 pages for object 'tbl_trpu_srar'.
DBCC results for 'tbl invoice sell header'.
There are 286 rows in 6 pages for object 'tbl invoice sell header'.
DBCC results for 'tbl stock wagon'.
There are 2087 rows in 54 pages for object 'tbl stock wagon'.
DBCC results for 'tbl stock zone global'.
There are 0 rows in 0 pages for object 'tbl stock zone global'.
DBCC results for 'tbl profitcenter'.
There are 1 rows in 1 pages for object 'tbl profitcenter'.
DBCC results for 'tbl model train'.
There are 0 rows in 0 pages for object 'tbl model train'.
DBCC results for 'tbl wagonowner'.
There are 0 rows in 0 pages for object 'tbl wagonowner'.
DBCC results for 'tbl currency price'.
There are 1 rows in 1 pages for object 'tbl currency price'.
DBCC results for 'tbl stock sods sdlg'.
There are 2433 rows in 14 pages for object 'tbl stock sods sdlg'.
DBCC results for 'tbl avisheader'.
There are 1 rows in 1 pages for object 'tbl avisheader'.
DBCC results for 'tbl stock dossier invoicing'.
There are 6 rows in 1 pages for object 'tbl stock dossier invoicing'.
DBCC results for 'tbl stock damage status'.
There are 0 rows in 0 pages for object 'tbl stock damage status'.
DBCC results for 'tbl invoice buy header'.
There are 434 rows in 10 pages for object 'tbl invoice buy header'.
DBCC results for 'tbl stock sdos swar'.
There are 0 rows in 0 pages for object 'tbl stock sdos swar'.
DBCC results for 'tbl stock type'.
There are 15 rows in 1 pages for object 'tbl stock type'.
DBCC results for 'tbl price type'.
There are 34 rows in 1 pages for object 'tbl price type'.
DBCC results for 'tbl stock outputdossier'.
There are 4119 rows in 96 pages for object 'tbl stock outputdossier'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'tbl stock outputdossier' (object ID 834570507).
DBCC results for 'tbl supplieroffice'.
There are 0 rows in 0 pages for object 'tbl supplieroffice'.
DBCC results for 'tbl currency'.
There are 1 rows in 1 pages for object 'tbl currency'.
DBCC results for 'tbl prices cost'.
There are 5 rows in 1 pages for object 'tbl prices cost'.
DBCC results for 'tbl trsn tcos'.
There are 0 rows in 0 pages for object 'tbl trsn tcos'.
DBCC results for 'tbl stock delivery message'.
There are 2429 rows in 21 pages for object 'tbl stock delivery message'.
DBCC results for 'tbl cim goods'.
There are 0 rows in 0 pages for object 'tbl cim goods'.
DBCC results for 'tbl stock dossier input'.
There are 8 rows in 1 pages for object 'tbl stock dossier input'.
DBCC results for 'tbl stock temp outputdossier'.
There are 1 rows in 1 pages for object 'tbl stock temp outputdossier'.
DBCC results for 'tbl phontype'.
There are 15 rows in 1 pages for object 'tbl phontype'.
DBCC results for 'tbl model cost'.
There are 6 rows in 1 pages for object 'tbl model cost'.
DBCC results for 'tbl supplier'.
There are 89 rows in 1 pages for object 'tbl supplier'.
DBCC results for 'tbl cubic sales'.
There are 7 rows in 1 pages for object 'tbl cubic sales'.
DBCC results for 'tbl TU NEGO BUY'.
There are 954 rows in 6 pages for object 'tbl TU NEGO BUY'.
DBCC results for 'tbl transportplan'.
There are 0 rows in 0 pages for object 'tbl transportplan'.
DBCC results for 'tbl phonComp'.
There are 3593 rows in 64 pages for object 'tbl phonComp'.
DBCC results for 'tbl stock quai'.
There are 10 rows in 1 pages for object 'tbl stock quai'.
DBCC results for 'tbl stock delivery global'.
There are 2544 rows in 66 pages for object 'tbl stock delivery global'.
DBCC results for 'tbl stock sorte'.
There are 59 rows in 1 pages for object 'tbl stock sorte'.
DBCC results for 'tbl owncompany'.
There are 5 rows in 1 pages for object 'tbl owncompany'.
DBCC results for 'tbl link model'.
There are 1512 rows in 8 pages for object 'tbl link model'.
DBCC results for 'tbl stock cross unit'.
There are 0 rows in 0 pages for object 'tbl stock cross unit'.
DBCC results for 'tbl cubic purchase'.
There are 6 rows in 1 pages for object 'tbl cubic purchase'.
DBCC results for 'tbl trpu trdt'.
There are 0 rows in 0 pages for object 'tbl trpu trdt'.
DBCC results for 'tbl trainrelation'.
There are 0 rows in 0 pages for object 'tbl trainrelation'.
DBCC results for 'tbl link trainrelatie'.
There are 0 rows in 0 pages for object 'tbl link trainrelatie'.
DBCC results for 'tbl stock destination'.
There are 151 rows in 4 pages for object 'tbl stock destination'.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1162078812)' (object ID 1162078812).
DBCC results for 'tbl stock preparation'.
There are 728 rows in 13 pages for object 'tbl stock preparation'.
DBCC results for 'tbl stock print barcode xml'.
There are 6 rows in 1 pages for object 'tbl stock print barcode xml'.
DBCC results for 'tbl numbering'.
There are 2 rows in 1 pages for object 'tbl numbering'.
DBCC results for 'tbl transportunit delete'.
There are 0 rows in 0 pages for object 'tbl transportunit delete'.
DBCC results for 'tbl stock'.
There are 13 rows in 1 pages for object 'tbl stock'.
DBCC results for 'tbl Country'.
There are 230 rows in 7 pages for object 'tbl Country'.
DBCC results for 'tbl trpu blok ok'.
There are 0 rows in 0 pages for object 'tbl trpu blok ok'.
DBCC results for 'tbl stock dossier'.
There are 10 rows in 1 pages for object 'tbl stock dossier'.
DBCC results for 'tbl intu statto'.
There are 0 rows in 0 pages for object 'tbl intu statto'.
DBCC results for 'tbl link traindate'.
There are 0 rows in 0 pages for object 'tbl link traindate'.
DBCC results for 'tbl stock acceptance'.
There are 0 rows in 0 pages for object 'tbl stock acceptance'.
DBCC results for 'tbl stock preparation group'.
There are 77 rows in 1 pages for object 'tbl stock preparation group'.
DBCC results for 'tbl non conformite'.
There are 0 rows in 0 pages for object 'tbl non conformite'.
DBCC results for 'tbl transportunit'.
There are 4261 rows in 304 pages for object 'tbl transportunit'.
DBCC results for 'tbl station'.
There are 697 rows in 22 pages for object 'tbl station'.
DBCC results for 'tbl cost type'.
There are 10 rows in 1 pages for object 'tbl cost type'.
DBCC results for 'tbl stock swag tu'.
There are 225 rows in 3 pages for object 'tbl stock swag tu'.
DBCC results for 'tbl stock cross unit comment'.
There are 0 rows in 0 pages for object 'tbl stock cross unit comment'.
DBCC results for 'tbl intu statfrom'.
There are 0 rows in 0 pages for object 'tbl intu statfrom'.
DBCC results for 'tbl link phonpers'.
There are 8143 rows in 38 pages for object 'tbl link phonpers'.
DBCC results for 'tbl link suivi wagon'.
There are 408 rows in 2 pages for object 'tbl link suivi wagon'.
DBCC results for 'tbl stock prefix'.
There are 15 rows in 1 pages for object 'tbl stock prefix'.
DBCC results for 'tbl log1'.
There are 106835 rows in 1207 pages for object 'tbl log1'.
DBCC results for 'tbl link suivi outputdossier'.
There are 0 rows in 0 pages for object 'tbl link suivi outputdossier'.
DBCC results for 'tbl resul line'.
There are 571 rows in 79 pages for object 'tbl resul line'.
DBCC results for 'tbl convpers'.
There are 0 rows in 0 pages for object 'tbl convpers'.
DBCC results for 'tbl generated prices sell'.
There are 4219 rows in 48 pages for object 'tbl generated prices sell'.
DBCC results for 'tbl resul detail'.
There are 1052 rows in 12 pages for object 'tbl resul detail'.
DBCC results for 'tbl cost per client'.
There are 0 rows in 0 pages for object 'tbl cost per client'.
DBCC results for 'tbl cim bijlage'.
There are 0 rows in 0 pages for object 'tbl cim bijlage'.
DBCC results for 'tbl stock wagon suivi'.
There are 18 rows in 1 pages for object 'tbl stock wagon suivi'.
DBCC results for 'tbl stock group outputdossier'.
There are 515 rows in 4 pages for object 'tbl stock group outputdossier'.
DBCC results for 'tbl convcomp'.
There are 0 rows in 0 pages for object 'tbl convcomp'.
DBCC results for 'tbl Language'.
There are 16 rows in 1 pages for object 'tbl Language'.
DBCC results for 'tbl_trpu_unique_cost'.
There are 0 rows in 0 pages for object 'tbl_trpu_unique_cost'.
DBCC results for 'tbl prospect'.
There are 0 rows in 0 pages for object 'tbl prospect'.
DBCC results for 'tbl cim goods trpu'.
There are 0 rows in 0 pages for object 'tbl cim goods trpu'.
DBCC results for 'tbl link pers'.
There are 3107 rows in 14 pages for object 'tbl link pers'.
DBCC results for 'tbl cim'.
There are 0 rows in 0 pages for object 'tbl cim'.
DBCC results for 'tbl_invoice_sell_other_line'.
There are 0 rows in 0 pages for object 'tbl_invoice_sell_other_line'.
DBCC results for 'tbl stock preparation control'.
There are 104 rows in 1 pages for object 'tbl stock preparation control'.
DBCC results for 'tbl Company'.
There are 4074 rows in 232 pages for object 'tbl Company'.
DBCC results for 'tbl stock family'.
There are 8 rows in 1 pages for object 'tbl stock family'.
DBCC results for 'tbl invoice sell type'.
There are 7 rows in 1 pages for object 'tbl invoice sell type'.
DBCC results for 'tbl stock deliveries'.
There are 3169 rows in 37 pages for object 'tbl stock deliveries'.
DBCC results for 'tbl producer'.
There are 13 rows in 1 pages for object 'tbl producer'.
DBCC results for 'tbl stock unit'.
There are 90833 rows in 2476 pages for object 'tbl stock unit'.
DBCC results for 'tbl intu coun'.
There are 0 rows in 0 pages for object 'tbl intu coun'.
DBCC results for 'tbl billing'.
There are 61 rows in 2 pages for object 'tbl billing'.
DBCC results for 'tbl_invoice_buy_other_line'.
There are 0 rows in 0 pages for object 'tbl_invoice_buy_other_line'.
DBCC results for 'tbl stock article'.
There are 484 rows in 9 pages for object 'tbl stock article'.
DBCC results for 'tbl cim zending'.
There are 2 rows in 1 pages for object 'tbl cim zending'.
DBCC results for 'tbl stock damage type'.
There are 10 rows in 1 pages for object 'tbl stock damage type'.
DBCC results for 'tbl invoice sale diff descr'.
There are 4 rows in 1 pages for object 'tbl invoice sale diff descr'.
DBCC results for 'temp stat form 43'.
There are 0 rows in 0 pages for object 'temp stat form 43'.
DBCC results for 'tbl link suivi tu'.
There are 83 rows in 1 pages for object 'tbl link suivi tu'.
DBCC results for 'tbl person'.
There are 3107 rows in 82 pages for object 'tbl person'.
DBCC results for 'tbl stock TU'.
There are 3922 rows in 21 pages for object 'tbl stock TU'.
DBCC results for 'tbl intu compsupp'.
There are 0 rows in 0 pages for object 'tbl intu compsupp'.
DBCC results for 'tbl avispers'.
There are 0 rows in 0 pages for object 'tbl avispers'.
DBCC results for 'tbl stock reference'.
There are 1238 rows in 10 pages for object 'tbl stock reference'.
DBCC results for 'tbl prices recieve offre'.
There are 0 rows in 0 pages for object 'tbl prices recieve offre'.
DBCC results for 'tbl cim station'.
There are 26422 rows in 267 pages for object 'tbl cim station'.
DBCC results for 'tbl stock damage place'.
There are 2 rows in 1 pages for object 'tbl stock damage place'.
DBCC results for 'temp stat form 41'.
There are 0 rows in 0 pages for object 'temp stat form 41'.
DBCC results for 'sysmergepublications'.
There are 1 rows in 1 pages for object 'sysmergepublications'.
DBCC results for 'tbl invoice buy diff descr'.
There are 10 rows in 1 pages for object 'tbl invoice buy diff descr'.
DBCC results for 'tbl invoice stock'.
There are 110267 rows in 4333 pages for object 'tbl invoice stock'.
DBCC results for 'tbl loader'.
There are 161 rows in 1 pages for object 'tbl loader'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'tbl generated prices buy'.
There are 7637 rows in 83 pages for object 'tbl generated prices buy'.
DBCC results for 'tbl intu compprod'.
There are 0 rows in 0 pages for object 'tbl intu compprod'.
DBCC results for 'tbl train date'.
There are 0 rows in 0 pages for object 'tbl train date'.
DBCC results for 'tbl recieve offre'.
There are 0 rows in 0 pages for object 'tbl recieve offre'.
DBCC results for 'temp mpur1'.
There are 0 rows in 0 pages for object 'temp mpur1'.
DBCC results for 'tbl model sales'.
There are 837 rows in 20 pages for object 'tbl model sales'.
DBCC results for 'tbl cim reisweg'.
There are 281 rows in 6 pages for object 'tbl cim reisweg'.
DBCC results for 'tbl stock damage cause'.
There are 10 rows in 1 pages for object 'tbl stock damage cause'.
DBCC results for 'tbl internetuser'.
There are 10 rows in 1 pages for object 'tbl internetuser'.
DBCC results for 'tbl cim partial loads'.
There are 0 rows in 0 pages for object 'tbl cim partial loads'.
DBCC results for 'tbl link comp'.
There are 4074 rows in 21 pages for object 'tbl link comp'.
DBCC results for 'tbl stock unit comment'.
There are 0 rows in 0 pages for object 'tbl stock unit comment'.
DBCC results for 'tbl intu compdest'.
There are 1 rows in 1 pages for object 'tbl intu compdest'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'hulpnorthen'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (hulpnorthen ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

[rudib]

Bonjour,

Regarde http://support.microsoft.com/kb/828339

Un problème de hardware ? Teste ton disque avec sqliosim : http://support.microsoft.com/kb/231619

[Julce]

merci Rubib,

j'avais déjà lu cette note de MS. D'après les logs de mon serveur, ce problème apparait (de temps en temps) lors des sauvegardes quotidiennes. Les DB sont répliquées vers d'autres serveurs et peut-etre un accès pour la réplication s'effectue en meme temps que l'accès aux données par le soft de backup ?

[rudib]

Il n'y a pas de raison que cela génère ce genre d'erreur

[Julce]

Ok merci Rubib,

Le problème est que c'est systèmatiquement après un backup que ce probleme arrive...
Etrange non ?

[rudib]

Tu as des erreurs dans ton DBCC CHECKDB, as-tu lancé DBCC CHECKDB avec un mode de REPAIR ?
Essaie d'abord REPAIR_REBUILD, si ça ne donne rien, passe à REPAIR_ALLOW_DATA_LOSS, en sachant que tu peux perdre des données.

[Julce]

Oui j'ai lancé le mode REPAIR_REBUILD mais pas le ALLOW_DATA_LOSS sachant que si je perds des données et que cette base commande une réplication, j'ai peur que la perte de ces données soient propagées sur mes autres bases.

Oulala c'est compliqué ces bases de données, moi j'suis juste un spécialiste réseaux...

[SQLpro]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
Le problème est que c'est systèmatiquement après un backup que ce probleme arrive...
Etrange non ?

Non pas du tout, et je vous conseille de changer de dique le plus rapidement possible en retrouvant une bonne sauvegarde !
Sachez qu'un disque endommagé risque fort de devenir rapidement totalement illisible...

Pas étrange du tout car les erreurs n'aparaissent qu'à la lecture des données. Comme certaines données sont rarement lues elles peuvent ne pas apparaître du tout, sauf lorsque l'on fait une sauvegarde qui oblige à lire toutes les pages de la base.

Si vous ne retrouvez pas de sauvegarde consistante, ou si votre dernière sauvegarde propre est ancienne, vous pouvez procéder comme suit :
MANIERE 1 :
1.1 passer la base en single user
1.2 désactiver les contraintes et triggers des tables suspectes
1.3 supprimer les tables suspectes
1.4 faire une sauvegarde
1.5 changer le disque
1.6 restaurer la sauvegarde
1.7 retrouver les données de ces tables depuis une sauvegarde plus ancienne et les réimplanter.

MANIERE 2 :
1.1 passer la base en single user
1.2 faire une sauvegarde
1.3 restaurer la base sur un serveur 2005
1.4 monter la base au niveau de compatibilité 90 (2005)
1.5 retrouver les pages de données des tables corrompues depuis une sauvegarde plus ancienne et les réimplanter en restauration PEACEMEAL.

A +

[Julce]

Merci beaucoup,

ca me rassure de voir que c'est un disque. Heureusement j'ai des sauvegardes quotidiennes sur cette machine. Donc je ne devrais pas avoir trop de problème pour changer le disque defectueux par un nouveau. Merci pour ton aide !

[Julce]

Non pas du tout, et je vous conseille de changer de dique le plus rapidement possible en retrouvant une bonne sauvegarde !
Sachez qu'un disque endommagé risque fort de devenir rapidement totalement illisible...

Je suis nouveau dans ma société et je n'avais pas vu mais le serveur comporte 3 disques SCSI en RAID5. Donc normalement si un problème de disque etait présent 2 disques sur 3 devrait pouvoir continuer à faire tourner le système sans probleme non ?
De plus j'ai un soft pour mes disques qui ne m'alerte d'aucune erreur...