Letšoao:

Ha o sebelisa TLHOKOMELISO DBCC le LOKISETSA_ALLOW_DATA_LOSS paramethara ho lokisa database e senyehileng ea .MDF, e kang ena:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

u bona molaetsa o latelang oa phoso:

Liphetho tsa DBCC tsa 'Error1'.
Ho lokisa: Boholo (1: 296) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Boholo (1: 304) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Boholo (1: 312) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Boholo (1: 328) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Boholo (1: 360) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Boholo (1: 376) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Boholo (1: 384) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Boholo (1: 400) bo tsamaisitsoe ho tloha ho ID 0, index ID -1, ID ea karohano 0, unit unit ea ID 0 (mofuta o sa tsejoeng).
Ho lokisa: Leqephe (1: 285) le tlositsoe ho tsoa ho ID 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown).
Ho lokisa: Leqephe (1: 287) le tlositsoe ho tsoa ho ID 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown).
Ho lokisa: Leqephe (1: 289) le tlositsoe ho tsoa ho ID 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown).
Ho lokisa: Leqephe (1: 291) le tlositsoe ho tsoa ho ID 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown).
Ho lokisa: Leqephe (1: 293) le tlositsoe ho tsoa ho ID 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown).
Ho lokisa: Leqephe (1: 368) le tlositsoe ho tsoa ho ID 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown).
Ho lokisa: Leqephe (1: 283) le tlositsoe ho tsoa ho ID 0, index ID -1, ID ea karohano 0, unit unit ID 27021597770317824 (mofuta Unknown).
Msg 8948, Level 16, State 3, Line 8
Phoso ea database: Leqephe (1: 284) le tšoailoe ka mofuta o fosahetseng ho leqephe la PFS (1: 1). Boemo ba PFS 0x70 bo lebelletsoeng 0x60.
Phoso e lokisitsoe.
Msg 8948, Level 16, State 3, Line 8
Phoso ea database: Leqephe (1: 286) le tšoailoe ka mofuta o fosahetseng ho leqephe la PFS (1: 1). Boemo ba PFS 0x70 bo lebelletsoeng 0x60.
Phoso e lokisitsoe.
Msg 8948, Level 16, State 3, Line 8
Phoso ea database: Leqephe (1: 288) le tšoailoe ka mofuta o fosahetseng ho leqephe la PFS (1: 1). Boemo ba PFS 0x70 bo lebelletsoeng 0x60.
Phoso e lokisitsoe.
Msg 8948, Level 16, State 3, Line 8
Phoso ea database: Leqephe (1: 290) le tšoailoe ka mofuta o fosahetseng ho leqephe la PFS (1: 1). Boemo ba PFS 0x70 bo lebelletsoeng 0x60.
Phoso e lokisitsoe.
Msg 8948, Level 16, State 3, Line 8
Phoso ea database: Leqephe (1: 292) le tšoailoe ka mofuta o fosahetseng ho leqephe la PFS (1: 1). Boemo ba PFS 0x70 bo lebelletsoeng 0x60.
Phoso e lokisitsoe.
Msg 8948, Level 16, State 3, Line 8
Phoso ea database: Leqephe (1: 294) le tšoailoe ka mofuta o fosahetseng ho leqephe la PFS (1: 1). Boemo ba PFS 0x70 bo lebelletsoeng 0x60.
Phoso e lokisitsoe.
Msg 8948, Level 16, State 3, Line 8
Phoso ea database: Leqephe (1: 295) le tšoailoe ka mofuta o fosahetseng ho leqephe la PFS (1: 1). Boemo ba PFS 0x70 bo lebelletsoeng 0x60.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 296) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 304) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 312) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 328) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 360) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8928, Level 16, State 6, Line 8
Ntho ea ID 0, index ID -1, ID ea karohano 0, unit unit ID 0 (mofuta o sa tsejoeng): Leqephe (1: 368) ha le khone ho sebetsoa. Bona liphoso tse ling bakeng sa lintlha.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 376) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 384) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8905, Level 16, State 1, Line 8
Bophara (1: 400) ho database ID ID 39 e tšoailoe e fanoe ho GAM, empa ha ho SGAM kapa IAM e e abileng.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 281475001417728 (mofuta Unknown), ID ea leqephe (1: 376) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (70:34).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 284) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 285) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 285) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (8074:44).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 286) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 287) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 287) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (7620:27).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 288) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 289) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 289) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (8053:29).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 290) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 291) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 291) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (7098:50).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 292) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 293) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 293) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (7098:50).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 294) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 295) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 313) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (7220:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 328) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (6846:34).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 368) ho database ID 39 e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 368) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (6:34).
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 385) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (7074:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597764222976 (mofuta Unknown), ID ea leqephe (1: 400) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (6818:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597769400320 (mofuta Unknown), ID ea leqephe (1: 296) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (4044:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597769465856 (mofuta Unknown), ID ea leqephe (1: 384) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (4076:34).
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 283) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597770317824 (mofuta Unknown), ID ea leqephe (1: 283) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (3374:54).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597783752704 (mofuta Unknown), ID ea leqephe (1: 297) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (10:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597783818240 (mofuta Unknown), ID ea leqephe (1: 298) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (18:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597783883776 (mofuta Unknown), ID ea leqephe (1: 299) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (42:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597783949312 (mofuta Unknown), ID ea leqephe (1: 300) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (14:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784014848 (mofuta Unknown), ID ea leqephe (1: 301) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (14:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784080384 (mofuta Unknown), ID ea leqephe (1: 302) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (32:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784145920 (mofuta Unknown), ID ea leqephe (1: 303) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (56:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784211456 (mofuta Unknown), ID ea leqephe (1: 304) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (34:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784276992 (mofuta Unknown), ID ea leqephe (1: 305) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (30:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784342528 (mofuta Unknown), ID ea leqephe (1: 306) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (10:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784408064 (mofuta Unknown), ID ea leqephe (1: 307) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (98:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784473600 (mofuta Unknown), ID ea leqephe (1: 308) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (34:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784539136 (mofuta Unknown), ID ea leqephe (1: 309) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (20:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784604672 (mofuta Unknown), ID ea leqephe (1: 310) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (38:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784670208 (mofuta Unknown), ID ea leqephe (1: 311) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (30:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597784735744 (mofuta Unknown), ID ea leqephe (1: 312) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (32:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597787881472 (mofuta Unknown), ID ea leqephe (1: 360) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (24:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597787947008 (mofuta Unknown), ID ea leqephe (1: 361) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (6:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597788012544 (mofuta Unknown), ID ea leqephe (1: 362) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (30:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597788078080 (mofuta Unknown), ID ea leqephe (1: 363) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (60:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597788143616 (mofuta Unknown), ID ea leqephe (1: 364) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (36:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597788209152 (mofuta Unknown), ID ea leqephe (1: 365) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (8:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597788274688 (mofuta Unknown), ID ea leqephe (1: 366) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (50:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597788864512 (mofuta Unknown), ID ea leqephe (1: 367) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (24:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597788995584 (mofuta Unknown), ID ea leqephe (1: 377) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (34:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597789061120 (mofuta Unknown), ID ea leqephe (1: 378) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (52:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597789126656 (mofuta Unknown), ID ea leqephe (1: 379) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (90:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597789192192 (mofuta Unknown), ID ea leqephe (1: 380) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (34:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597789257728 (mofuta Unknown), ID ea leqephe (1: 381) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (52:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597789323264 (mofuta Unknown), ID ea leqephe (1: 382) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (76:34).
Msg 8909, Level 16, State 1, Line 8
Phoso ea tafole: ID ea ntho 0, index ID -1, ID ea karohano 0, unit unit ID 27021597789388800 (mofuta Unknown), ID ea leqephe (1: 383) e na le ID ea leqephe le fosahetseng hloohong ea leqephe la eona. Leqephe la leqephe hloohong = (16:34).
CHECKDB e fumane liphoso tse 31 tsa kabo le liphoso tse 44 tse sa amaneng le letho.
CHECKDB e hlophisitse liphoso tse 31 tsa kabo le liphoso tse 0 tse sa amaneng le letho.
Tokiso: IAM chain for object ID 27, index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (type In-row data), e khutsufalitsoe pele ho leqephe (1: 288) 'me e tla hahuoa bocha.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 288) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 27, index ID 2, karohano ID 562949955190784, unit unit ID 562949955190784 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Phoso e lokisitsoe.
CHECKDB e fumane liphoso tse 1 tsa kabo le liphoso tse 0 tse sa fetoheng tafoleng 'sys.sysowners' (ntho ea ID 27).
CHECKDB e hlophisitse liphoso tsa kabo ea 1 le liphoso tse 0 tse sa fetoheng tafoleng ea 'sysysersers' (ntho ea ID 27).
Ho lokisa: Leqephe (1:79) le abetsoe ntho ea ID 34, index ID 2, ID ea karohano 562949955649536, unit unit ea ID 562949955649536 (mofuta oa In-row data).
Tokiso: IAM chain for object ID 34, index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data), e khutsufalitsoe pele ho leqephe (1: 295) 'me e tla hahuoa bocha.
Ho lokisa: Leqephe (1:80) le abetsoe ntho ea ID 34, index ID 3, ID ea karohano 844424932360192, unit unit ea ID 844424932360192 (mofuta oa In-row data).
Tokiso: IAM chain for object ID 34, index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data), e khutsufalitsoe pele ho leqephe (1: 368) 'me e tla hahuoa bocha.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 79) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 295) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 34, index ID 2, karohano ID 562949955649536, unit unit ID 562949955649536 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Phoso e lokisitsoe.
Msg 8906, Level 16, State 1, Line 8
Leqephe (1: 80) ho database 39 ID e abiloe ho SGAM (1: 3) le PFS (1: 1), empa ha ea ka ea abeloa IAM efe kapa efe. Lifolakha tsa PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Phoso e lokisitsoe.
Msg 2575, Level 16, State 1, Line 8
Leqephe la Index Allocation Map (IAM) (1: 368) le supisoa ke sesupi se latelang sa leqephe la IAM (0: 0) ho ID 34, index ID 3, karohano ID 844424932360192, unit unit ID 844424932360192 (mofuta In-row) data), empa ha ea ka ea fumanoa ho scan.
Phoso e lokisitsoe.
Msg 824, Level 24, State 2, Line 8
SQL Server e fumane phoso e hlakileng ea I / O e thehiloeng ho ts'ebetsong: leqephe le fosahetseng (le lebelletsoe 1: 261; 114: 34 ea nnete) E etsahetse nakong ea ha ho baloa leqephe (1: 261) ho database ID 39 ho offset 0x0000000020a000 ho file 'C: Program Files SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Melaetsa e meng ho SQL Server log ea phoso kapa log ea ketsahalo ea sistimi e ka fana ka lintlha tse ling hape. Ena ke phoso e matla e sokelang seriti sa database mme e tlameha ho lokisoa hanghang. Tlatsa tlhahlobo e felletseng ea database (DBCC CHECKDB). Phoso ena e ka bakoa ke lintlha tse ngata; bakeng sa tlhaiso-leseling e batsi, bona SQL Server Libuka Inthaneteng.
Msg 824, Level 24, State 2, Line 8
SQL Server e fumane phoso e hlakileng ea I / O e thehiloeng ho ts'ebetsong: leqephe le fosahetseng (ho lebelletsoe 1: 369; 40:60 ea nnete). E etsahetse nakong ea ha ho baloa leqephe (1: 369) ho database ID 39 ho offset 0x000000002e2000 ho file 'C: Program Files SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Melaetsa e meng ho SQL Server log ea phoso kapa log ea ketsahalo ea sistimi e ka fana ka lintlha tse ling hape. Ena ke phoso e matla e sokelang seriti sa database mme e tlameha ho lokisoa hanghang. Tlatsa tlhahlobo e felletseng ea database (DBCC CHECKDB). Phoso ena e ka bakoa ke lintlha tse ngata; bakeng sa tlhaiso-leseling e batsi, bona SQL Server Libuka Inthaneteng.

moo 'Error1' e leng lebitso la database e senyehileng ea MDF e lokisoang.

Msg 8905 e bonts'a boholo bo abetsoe GAM, empa ha ho SGAM kapa IAM e e abileng. Ena ke phoso ea kabo.

Screenshot ea molaetsa oa phoso:

Tlhaloso e hlakileng:

Ho database ea MDF, lintlha li bolokiloe joalo ka maqepheng. GAM, SGAM le IAM kaofela li sebelisoa bakeng sa likabo. Lintlha li fanoe ka yuniti ea boholo (maqephe a 8) ho fapana le leqephe le le leng ho ntlafatsa ts'ebetso. Haeba tekanyo e fanoe ke GAM empa e sa abuoa ke SGAM kapa IAM, CHECKDB e tla tlaleha Msg 8905, ebe o leka ho e lokisa.

U ka sebelisa sehlahisoa sa rona DataNumen SQL Recovery ho khutlisa data ho tsoa faeleng e senyehileng ea MDF le ho rarolla phoso ena.

Mohlala File 1:

Mohlala oa lifaele tsa MDF tse senyehileng tseo TLHOKOMELO LOKISETSA_ALLOW_DATA_LOSS o tla fumana Msg 8905 Phoso, empa HA U khone ho fumana database, ha DataNumen SQL Recovery ka khona.

SQL Server tlhahiso Faele ea MDF e senyehileng Faele ea MDF e hlophisitsoeng ke DataNumen SQL Recovery
SQL Server 2014 Phoso 11.mdf Phoso11_fixed.mdf