Ruzivo rwakadzama nezve CHECKDB Kanganiso "Kuwedzera (##:##) MuDatabase ID ## Yakanyorwa Yakagoverwa MuGamu, Asi Hapana Sgam Kana Iam Yakaigovera"

Chiratidzo:

Paunenge uchishandisa DBCC CHECKDB ne REPAIR_ALLOW_DATA_LOSS parameter kugadzirisa yakaora .MDF dhatabhesi, seizvi:

DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')

iwe unoona inotevera meseji yekukanganisa:

DBCC mhinduro dze'Error1'.
Kugadzirisa: Iyo yakakura (1: 296) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo yakakura (1: 304) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo yakakura (1: 312) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo yakakura (1: 328) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo yakakura (1: 360) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo yakakura (1: 376) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo yakakura (1: 384) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo yakakura (1: 400) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 0 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo peji (1: 285) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo peji (1: 287) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo peji (1: 289) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo peji (1: 291) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo peji (1: 293) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo peji (1: 368) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe).
Kugadzirisa: Iyo peji (1: 283) yakatorwa kubva kuchinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597770317824 (rudzi rusingazivikanwe).
Msg 8948, Chikamu 16, State 3, Mutsara 8
Database kukanganisa: Peji (1:284) yakanyorwa nemhando isiriyo muPFS peji (1:1). PFS chimiro 0x70 inotarisirwa 0x60.
Iko kukanganisa kwagadziriswa.
Msg 8948, Chikamu 16, State 3, Mutsara 8
Database kukanganisa: Peji (1:286) yakanyorwa nemhando isiriyo muPFS peji (1:1). PFS chimiro 0x70 inotarisirwa 0x60.
Iko kukanganisa kwagadziriswa.
Msg 8948, Chikamu 16, State 3, Mutsara 8
Database kukanganisa: Peji (1:288) yakanyorwa nemhando isiriyo muPFS peji (1:1). PFS chimiro 0x70 inotarisirwa 0x60.
Iko kukanganisa kwagadziriswa.
Msg 8948, Chikamu 16, State 3, Mutsara 8
Database kukanganisa: Peji (1:290) yakanyorwa nemhando isiriyo muPFS peji (1:1). PFS chimiro 0x70 inotarisirwa 0x60.
Iko kukanganisa kwagadziriswa.
Msg 8948, Chikamu 16, State 3, Mutsara 8
Database kukanganisa: Peji (1:292) yakanyorwa nemhando isiriyo muPFS peji (1:1). PFS chimiro 0x70 inotarisirwa 0x60.
Iko kukanganisa kwagadziriswa.
Msg 8948, Chikamu 16, State 3, Mutsara 8
Database kukanganisa: Peji (1:294) yakanyorwa nemhando isiriyo muPFS peji (1:1). PFS chimiro 0x70 inotarisirwa 0x60.
Iko kukanganisa kwagadziriswa.
Msg 8948, Chikamu 16, State 3, Mutsara 8
Database kukanganisa: Peji (1:295) yakanyorwa nemhando isiriyo muPFS peji (1:1). PFS chimiro 0x70 inotarisirwa 0x60.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:296) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:304) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:312) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:328) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:360) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8928, Chikamu 16, State 6, Mutsara 8
Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown): Peji (1:368) yatadza kugadziriswa. Ona zvimwe zvikanganiso kuti uwane ruzivo.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:376) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:384) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8905, Chikamu 16, State 1, Mutsara 8
Kuwedzera (1:400) mudatabase ID 39 yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yakapa.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 281475001417728 (rudzi rusingazivikanwe), peji ID (1:376) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (70: 34).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:284) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:285) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:285) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (8074: 44).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:286) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:287) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:287) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (7620: 27).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:288) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:289) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:289) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (8053: 29).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:290) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:291) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:291) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (7098: 50).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:292) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:293) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:293) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (7098: 50).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:294) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:295) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:313) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (7220: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:328) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (6846: 34).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:368) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:368) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (6: 34).
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:385) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (7074: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597764222976 (rudzi rusingazivikanwe), peji ID (1:400) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (6818: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597769400320 (rudzi rusingazivikanwe), peji ID (1:296) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (4044: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597769465856 (rudzi rusingazivikanwe), peji ID (1:384) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (4076: 34).
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:283) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597770317824 (rudzi rusingazivikanwe), peji ID (1:283) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (3374: 54).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597783752704 (rudzi rusingazivikanwe), peji ID (1:297) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (10: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597783818240 (rudzi rusingazivikanwe), peji ID (1:298) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (18: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597783883776 (rudzi rusingazivikanwe), peji ID (1:299) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (42: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597783949312 (rudzi rusingazivikanwe), peji ID (1:300) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (14: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784014848 (rudzi rusingazivikanwe), peji ID (1:301) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (14: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784080384 (rudzi rusingazivikanwe), peji ID (1:302) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (32: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784145920 (rudzi rusingazivikanwe), peji ID (1:303) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (56: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784211456 (rudzi rusingazivikanwe), peji ID (1:304) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (34: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784276992 (rudzi rusingazivikanwe), peji ID (1:305) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (30: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784342528 (rudzi rusingazivikanwe), peji ID (1:306) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (10: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784408064 (rudzi rusingazivikanwe), peji ID (1:307) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (98: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784473600 (rudzi rusingazivikanwe), peji ID (1:308) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (34: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784539136 (rudzi rusingazivikanwe), peji ID (1:309) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (20: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784604672 (rudzi rusingazivikanwe), peji ID (1:310) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (38: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784670208 (rudzi rusingazivikanwe), peji ID (1:311) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (30: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597784735744 (rudzi rusingazivikanwe), peji ID (1:312) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (32: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597787881472 (rudzi rusingazivikanwe), peji ID (1:360) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (24: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597787947008 (rudzi rusingazivikanwe), peji ID (1:361) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (6: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597788012544 (rudzi rusingazivikanwe), peji ID (1:362) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (30: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597788078080 (rudzi rusingazivikanwe), peji ID (1:363) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (60: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597788143616 (rudzi rusingazivikanwe), peji ID (1:364) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (36: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597788209152 (rudzi rusingazivikanwe), peji ID (1:365) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (8: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597788274688 (rudzi rusingazivikanwe), peji ID (1:366) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (50: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597788864512 (rudzi rusingazivikanwe), peji ID (1:367) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (24: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597788995584 (rudzi rusingazivikanwe), peji ID (1:377) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (34: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597789061120 (rudzi rusingazivikanwe), peji ID (1:378) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (52: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597789126656 (rudzi rusingazivikanwe), peji ID (1:379) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (90: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597789192192 (rudzi rusingazivikanwe), peji ID (1:380) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (34: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597789257728 (rudzi rusingazivikanwe), peji ID (1:381) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (52: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597789323264 (rudzi rusingazivikanwe), peji ID (1:382) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (76: 34).
Msg 8909, Chikamu 16, State 1, Mutsara 8
Tafura kukanganisa: Chinhu ID 0, index ID -1, partition ID 0, alloc unit ID 27021597789388800 (rudzi rusingazivikanwe), peji ID (1:383) ine peji ID isiriyo mumusoro wepeji. Iyo PejiId mumusoro wepeji = (16: 34).
CHECKDB yakawana 31 zvikanganiso zvekugovera uye 44 zvikanganiso zvisina hukama nechero chinhu chimwe chete.
CHECKDB yakagadziriswa 31 zvikanganiso zvekugovera uye makumi maviri nemana zvikanganiso zvisina hukama nechero chinhu chimwe chete.
Kugadzirisa: IAM cheni yechinhu ID 27, index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (type In-row data), yakatemwa pamberi pepeji (1:288) uye ichavakwazve.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:288) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 27, index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (type In-row data), asi haina kuwanikwa mu scan.
Iko kukanganisa kwagadziriswa.
CHECKDB yakawana zvikanganiso zvekugovera 1 uye 0 zvikanganiso zvekuenderana mutafura 'sys.sysowners' (chinhu ID 27).
CHECKDB yakagadzirisa 1 zvikanganiso zvekugovera uye 0 kusawirirana kukanganisa mutafura 'sys.sysowners' (chinhu ID 27).
Kugadzirisa: Iyo peji (1: 79) yakagoverwa kune chinhu ID 34, index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data).
Kugadzirisa: IAM cheni yechinhu ID 34, index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data), yakatemwa pamberi pepeji (1:295) uye ichavakwazve.
Kugadzirisa: Iyo peji (1: 80) yakagoverwa kune chinhu ID 34, index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data).
Kugadzirisa: IAM cheni yechinhu ID 34, index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data), yakatemwa pamberi pepeji (1:368) uye ichavakwazve.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:79) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:295) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 34, index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data), asi haina kuwanikwa mu scan.
Iko kukanganisa kwagadziriswa.
Msg 8906, Chikamu 16, State 1, Mutsara 8
Peji (1:80) mudatabase ID 39 yakagoverwa muSGAM (1:3) nePFS (1:1), asi haina kugoverwa mune chero IAM. PFS mireza 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Iko kukanganisa kwagadziriswa.
Msg 2575, Chikamu 16, State 1, Mutsara 8
Iyo Index Allocation Mepu (IAM) peji (1:368) inonongedzerwa kune inotevera pointer yeIAM peji (0:0) muchinhu ID 34, index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data), asi haina kuwanikwa mu scan.
Iko kukanganisa kwagadziriswa.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa-kwakavakirwa I/O kukanganisa: pejiid isiriyo (inotarisirwa 1:261; chaiyo 114:34). Zvakaitika panguva yekuverenga peji (1:261) mudhatabhesi ID 39 pakubvisa 0x0000000020a000 mufaira 'C:Program FilesMicrosoft. SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.
Msg 824, Chikamu 24, State 2, Mutsara 8
SQL Server yakaona kukanganisa-kwakavakirwa I/O kukanganisa: pejiid isiriyo (inotarisirwa 1:369; chaiyo 40:60). Zvakaitika panguva yekuverengwa kwepeji (1:369) mu database ID 39 pa offset 0x000000002e2000 mufaira 'C:Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf'. Mamwe mameseji mu SQL Server kukanganisa log kana system chiitiko log inogona kupa rumwe ruzivo. Ichi chikanganiso chakakomba chinotyisidzira kuvimbika kwedatabase uye inofanirwa kugadziriswa nekukasira. Zadzisa yakazara dhatabhesi kuenderana cheki (DBCC CHECKDB). Kukanganisa uku kunogona kukonzerwa nezvinhu zvakawanda; kuti uwane rumwe ruzivo, ona SQL Server Books Online.

uko 'Error1' izita rehuori MDF dhatabhesi iri kugadziriswa.

Msg 8905 inoratidza chiyero chakagoverwa kuGAM, asi hapana SGAM kana IAM yakapa. Uku ndiko kukanganisa kwekugoverwa.

Screenshot yemhosho meseji:

Tsanangudzo Yakananga:

Mune MDF dhatabhesi, iyo data inochengetwa se mapeji. GAM, SGAM uye IAM ese anoshandiswa pakugoverwa. Uye iyo data yakagoverwa muchikamu chechiyero (8 mapeji) pachinzvimbo chepeji rimwe kuvandudza mashandiro. Kana chiyero chakagoverwa neGAM asi chisina kupihwa neSGAM kana IAM, saka CHECKDB ichataura. Msg 8905, uye woedza kuzvigadzirisa.

Unogona kushandisa chigadzirwa chedu DataNumen SQL Recovery kuti uwanezve data kubva kune yakaora MDF faira uye kugadzirisa kukanganisa uku.

Muenzaniso faira 1:

Sample yakaora MDF mafaera pane CHECKDB REPAIR_ALLOW_DATA_LOSS tsvaga Msg 8905 kukanganisa, asi HAUgone kudzoreredza dhatabhesi, uku DataNumen SQL Recovery anogona.

SQL Server mhando	Uori MDF faira	MDF faira rakagadziriswa ne DataNumen SQL Recovery
SQL Server 2014	Kukanganisa11.mdf	Error11_fixed.mdf