Cov ncauj lus kom ntxaws txog CHECKDB Kev Ua yuam kev "Ntev (##: ##) Hauv Database Id ## Muaj Cim Ntaus Hauv Gam, Tab sis Tsis Sgam Lossis Iam Tau Cais Nws"

Cov tsos mob:

Thaum siv DBCC CHECKDB nrog REPAIR_ALLOW_DATA_LOS parameter los kho qhov tsis ncaj .MDF database, zoo li no:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

koj pom cov lus yuam kev li hauv qab no:

DBCC cov txiaj ntsig rau 'Error1'.
Kho: Qhov raws li (1: 296) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kho: Qhov raws li (1: 304) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kho: Qhov raws li (1: 312) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kho: Qhov raws li (1: 328) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kho: Qhov raws li (1: 360) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kho: Qhov raws li (1: 376) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kho: Qhov raws li (1: 384) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kho: Qhov raws li (1: 400) tau tawm ntawm kwv ID 0, Performance index -1, muab faib ID 0, faib chav ID 0 (hom Tsis paub).
Kev Kho: Cov nplooj ntawv (1: 285) tau tawm ntawm cov kwv ID 0, Performance index ID-1, muab faib ID 0, faib cov lej ID 27021597764222976 (hom Tsis paub).
Kev Kho: Cov nplooj ntawv (1: 287) tau tawm ntawm cov kwv ID 0, Performance index ID-1, muab faib ID 0, faib cov lej ID 27021597764222976 (hom Tsis paub).
Kev Kho: Cov nplooj ntawv (1: 289) tau tawm ntawm cov kwv ID 0, Performance index ID-1, muab faib ID 0, faib cov lej ID 27021597764222976 (hom Tsis paub).
Kev Kho: Cov nplooj ntawv (1: 291) tau tawm ntawm cov kwv ID 0, Performance index ID-1, muab faib ID 0, faib cov lej ID 27021597764222976 (hom Tsis paub).
Kev Kho: Cov nplooj ntawv (1: 293) tau tawm ntawm cov kwv ID 0, Performance index ID-1, muab faib ID 0, faib cov lej ID 27021597764222976 (hom Tsis paub).
Kev Kho: Cov nplooj ntawv (1: 368) tau tawm ntawm cov kwv ID 0, Performance index ID-1, muab faib ID 0, faib cov lej ID 27021597764222976 (hom Tsis paub).
Kev Kho: Cov nplooj ntawv (1: 283) tau tawm ntawm cov kwv ID 0, Performance index ID-1, muab faib ID 0, faib cov lej ID 27021597770317824 (hom Tsis paub).
Msg 8948, Qib 16, 3 Xeev, Kab 8
Cov ntaub ntawv yuam kev: Nplooj (1: 284) yog cim nrog cov hom tsis raug hauv PFS nplooj ntawv (1: 1). PFS xwm txheej 0x70 xav tau 0x60.
Qhov yuam kev tau raug kho.
Msg 8948, Qib 16, 3 Xeev, Kab 8
Cov ntaub ntawv yuam kev: Nplooj (1: 286) yog cim nrog cov hom tsis raug hauv PFS nplooj ntawv (1: 1). PFS xwm txheej 0x70 xav tau 0x60.
Qhov yuam kev tau raug kho.
Msg 8948, Qib 16, 3 Xeev, Kab 8
Cov ntaub ntawv yuam kev: Nplooj (1: 288) yog cim nrog cov hom tsis raug hauv PFS nplooj ntawv (1: 1). PFS xwm txheej 0x70 xav tau 0x60.
Qhov yuam kev tau raug kho.
Msg 8948, Qib 16, 3 Xeev, Kab 8
Cov ntaub ntawv yuam kev: Nplooj (1: 290) yog cim nrog cov hom tsis raug hauv PFS nplooj ntawv (1: 1). PFS xwm txheej 0x70 xav tau 0x60.
Qhov yuam kev tau raug kho.
Msg 8948, Qib 16, 3 Xeev, Kab 8
Cov ntaub ntawv yuam kev: Nplooj (1: 292) yog cim nrog cov hom tsis raug hauv PFS nplooj ntawv (1: 1). PFS xwm txheej 0x70 xav tau 0x60.
Qhov yuam kev tau raug kho.
Msg 8948, Qib 16, 3 Xeev, Kab 8
Cov ntaub ntawv yuam kev: Nplooj (1: 294) yog cim nrog cov hom tsis raug hauv PFS nplooj ntawv (1: 1). PFS xwm txheej 0x70 xav tau 0x60.
Qhov yuam kev tau raug kho.
Msg 8948, Qib 16, 3 Xeev, Kab 8
Cov ntaub ntawv yuam kev: Nplooj (1: 295) yog cim nrog cov hom tsis raug hauv PFS nplooj ntawv (1: 1). PFS xwm txheej 0x70 xav tau 0x60.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 296) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 304) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 312) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 328) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 360) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8928, Qib 16, 6 Xeev, Kab 8
Lub Hom Phiaj ID 0, Performance index ID-1, muab faib ID 0, muab faib rau koog 0 (hom tsis paub): Nplooj (1: 368) tsis tuaj yeem ua tiav. Saib lwm yam yuam kev rau cov ntsiab lus.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 376) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 384) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8905, Qib 16, 1 Xeev, Kab 8
Ntu (1: 400) hauv database ID 39 yog cim tseg nyob hauv GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 281475001417728 (yam tsis paub), nplooj ntawv ID (1: 376) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (70: 34).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 284) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 285) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 285) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (8074: 44).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 286) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 287) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 287) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (7620: 27).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 288) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 289) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 289) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (8053: 29).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 290) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 291) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 291) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (7098: 50).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 292) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 293) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 293) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (7098: 50).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 294) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 295) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 313) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (7220: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 328) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (6846: 34).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 368) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'IAM_PG MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 368) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (6: 34).
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 385) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (7074: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597764222976 (yam tsis paub), nplooj ntawv ID (1: 400) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (6818: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597769400320 (yam tsis paub), nplooj ntawv ID (1: 296) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (4044: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597769465856 (yam tsis paub), nplooj ntawv ID (1: 384) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (4076: 34).
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 283) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597770317824 (yam tsis paub), nplooj ntawv ID (1: 283) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (3374: 54).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597783752704 (yam tsis paub), nplooj ntawv ID (1: 297) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (10: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597783818240 (yam tsis paub), nplooj ntawv ID (1: 298) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (18: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597783883776 (yam tsis paub), nplooj ntawv ID (1: 299) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (42: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597783949312 (yam tsis paub), nplooj ntawv ID (1: 300) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (14: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784014848 (yam tsis paub), nplooj ntawv ID (1: 301) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (14: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784080384 (yam tsis paub), nplooj ntawv ID (1: 302) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (32: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784145920 (yam tsis paub), nplooj ntawv ID (1: 303) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (56: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784211456 (yam tsis paub), nplooj ntawv ID (1: 304) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (34: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784276992 (yam tsis paub), nplooj ntawv ID (1: 305) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (30: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784342528 (yam tsis paub), nplooj ntawv ID (1: 306) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (10: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784408064 (yam tsis paub), nplooj ntawv ID (1: 307) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (98: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784473600 (yam tsis paub), nplooj ntawv ID (1: 308) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (34: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784539136 (yam tsis paub), nplooj ntawv ID (1: 309) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (20: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784604672 (yam tsis paub), nplooj ntawv ID (1: 310) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (38: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784670208 (yam tsis paub), nplooj ntawv ID (1: 311) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (30: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597784735744 (yam tsis paub), nplooj ntawv ID (1: 312) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (32: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597787881472 (yam tsis paub), nplooj ntawv ID (1: 360) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (24: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597787947008 (yam tsis paub), nplooj ntawv ID (1: 361) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (6: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597788012544 (yam tsis paub), nplooj ntawv ID (1: 362) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (30: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597788078080 (yam tsis paub), nplooj ntawv ID (1: 363) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (60: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597788143616 (yam tsis paub), nplooj ntawv ID (1: 364) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (36: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597788209152 (yam tsis paub), nplooj ntawv ID (1: 365) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (8: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597788274688 (yam tsis paub), nplooj ntawv ID (1: 366) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (50: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597788864512 (yam tsis paub), nplooj ntawv ID (1: 367) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (24: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597788995584 (yam tsis paub), nplooj ntawv ID (1: 377) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (34: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597789061120 (yam tsis paub), nplooj ntawv ID (1: 378) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (52: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597789126656 (yam tsis paub), nplooj ntawv ID (1: 379) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (90: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597789192192 (yam tsis paub), nplooj ntawv ID (1: 380) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (34: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597789257728 (yam tsis paub), nplooj ntawv ID (1: 381) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (52: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597789323264 (yam tsis paub), nplooj ntawv ID (1: 382) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (76: 34).
Msg 8909, Qib 16, 1 Xeev, Kab 8
Cov lus tsis raug: Cov Khoom ID 0, Performance index ID-1, muab faib ID 0, faib chav ID 27021597789388800 (yam tsis paub), nplooj ntawv ID (1: 383) muaj nplooj tsis raug tus ID hauv nws cov kab ntawv nplooj. Cov ntawv PageId hauv nplooj ntawv header = (16: 34).
CHECKDB pom 31 faib yuam kev thiab 44 qhov ua yuam kev tsis raug cuam tshuam nrog ib yam twj paj nruas.
CHECKDB tsau 31 cov teeb meem tsis raug thiab 0 qhov tseeb yuam kev tsis cuam tshuam nrog ib yam twj paj nruas.
Kho: IAM saw rau cov khoom ID 27, Performance index ID 2, muab faib ID 562949955190784, faib koog ID 562949955190784 (hom Cov Kab Hauv Cov Ntaub Ntawv), tau txiav ua ntej nplooj ntawv (1: 288) thiab yuav rov tsim dua.
Msg 2575, Qib 16, 1 Xeev, Kab 8
Daim phiaj qhia Kev Ntsuam Xyuas Txoj Haujlwm (IAM) nplooj ntawv (1: 288) yog taw qhia los ntawm tus taw tes tom ntej ntawm IAM nplooj ntawv (0: 0) nyob rau hauv khoom ID 27, Performance index ID 2, muab faib ID 562949955190784, faib koog ID 562949955190784 (hom Hauv Kab cov ntaub ntawv), tab sis nws tsis pom nyob rau hauv scan.
Qhov yuam kev tau raug kho.
CHECKDB pom 1 qhov kev faib yuam kev thiab 0 yuam kev hauv cov lus 'sys.sysowners' (kwv ID 27).
CHECKDB tsau 1 cov teeb meem tsis sib haum thiab 0 sib xws kom raug hauv cov lus 'sys.sysowners' (kwv ID 27).
Kev Kho: Cov nplooj ntawv (1:79) tau faib rau cov khoom ID 34, Performance index ID 2, muab faib ID 562949955649536, faib chav cim ID 562949955649536 (hom Cov Kab Hauv Cov Ntaub Ntawv).
Kho: IAM saw rau cov khoom ID 34, Performance index ID 2, muab faib ID 562949955649536, faib koog ID 562949955649536 (hom Cov Kab Hauv Cov Ntaub Ntawv), tau txiav ua ntej nplooj ntawv (1: 295) thiab yuav rov tsim dua.
Kev Kho: Cov nplooj ntawv (1:80) tau faib rau cov khoom ID 34, Performance index ID 3, muab faib ID 844424932360192, faib chav cim ID 844424932360192 (hom Cov Kab Hauv Cov Ntaub Ntawv).
Kho: IAM saw rau cov khoom ID 34, Performance index ID 3, muab faib ID 844424932360192, faib koog ID 844424932360192 (hom Cov Kab Hauv Cov Ntaub Ntawv), tau txiav ua ntej nplooj ntawv (1: 368) thiab yuav rov tsim dua.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 79) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 2575, Qib 16, 1 Xeev, Kab 8
Daim phiaj qhia Kev Ntsuam Xyuas Txoj Haujlwm (IAM) nplooj ntawv (1: 295) yog taw qhia los ntawm tus taw tes tom ntej ntawm IAM nplooj ntawv (0: 0) nyob rau hauv khoom ID 34, Performance index ID 2, muab faib ID 562949955649536, faib koog ID 562949955649536 (hom Hauv Kab cov ntaub ntawv), tab sis nws tsis pom nyob rau hauv scan.
Qhov yuam kev tau raug kho.
Msg 8906, Qib 16, 1 Xeev, Kab 8
Nplooj ntawv (1: 80) hauv database ID 39 tau faib nyob rau hauv SGAM (1: 3) thiab PFS (1: 1), tab sis tsis tau faib rau hauv IAM. PFS chij 'MIXED_EXT TXHUA 0_PCT_FULL'.
Qhov yuam kev tau raug kho.
Msg 2575, Qib 16, 1 Xeev, Kab 8
Daim phiaj qhia Kev Ntsuam Xyuas Txoj Haujlwm (IAM) nplooj ntawv (1: 368) yog taw qhia los ntawm tus taw tes tom ntej ntawm IAM nplooj ntawv (0: 0) nyob rau hauv khoom ID 34, Performance index ID 3, muab faib ID 844424932360192, faib koog ID 844424932360192 (hom Hauv Kab cov ntaub ntawv), tab sis nws tsis pom nyob rau hauv scan.
Qhov yuam kev tau raug kho.
Msg 824, Qib 24, 2 Xeev, Kab 8
SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog pageid (kev cia siab 1: 261; tseeb 114: 34). Nws tau tshwm sim thaum nyeem ntawm nplooj ntawv (1: 261) hauv database ID 39 ntawm kev suav 0x0000000020a000 hauv cov ntaub ntawv 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Cov lus qhia ntxiv hauv SQL Server log cav yuam kev lossis cov txheej xwm kaw lus yuav qhia ntau yam. Qhov no yog qhov ua yuam kev loj heev uas cuam tshuam rau database kev ncaj ncees thiab yuav tsum raug kho tam sim. Ua kom tiav qhov kev txheeb xyuas tag nrho cov ntaub ntawv (DBCC CHECKDB). Qhov kev ua yuam kev no tuaj yeem tshwm sim los ntawm ntau yam; rau cov lus qhia ntxiv, saib SQL Server Phau Ntawv Online.
Msg 824, Qib 24, 2 Xeev, Kab 8
SQL Server kuaj pom qhov ua kom tsis raug raws li I / O yuam kev: tsis yog pageid (xav tias 1: 369; tiag tiag 40: 60). Nws tau tshwm sim thaum nyeem ntawm nplooj ntawv (1: 369) hauv database ID 39 ntawm kev suav 0x000000002e2000 hauv cov ntawv 'C: Program FilesMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Cov lus qhia ntxiv hauv SQL Server log cav yuam kev lossis cov txheej xwm kaw lus yuav qhia ntau yam. Qhov no yog qhov ua yuam kev loj heev uas cuam tshuam rau database kev ncaj ncees thiab yuav tsum raug kho tam sim. Ua kom tiav qhov kev txheeb xyuas tag nrho cov ntaub ntawv (DBCC CHECKDB). Qhov kev ua yuam kev no tuaj yeem tshwm sim los ntawm ntau yam; rau cov lus qhia ntxiv, saib SQL Server Phau Ntawv Online.

qhov twg 'Error1' yog lub npe ntawm tus tsis ncaj MDF database tau raug kho.

Wb 8905 qhia tias qhov twg yog faib rau GAM, tab sis tsis muaj SGAM lossis IAM tau faib rau nws. Nov yog kev faib qee yam yuam kev.

Screenshot ntawm cov lus yuam:

Nqe Lus Qhia Tshwj Xeeb:

Hauv MDF cov ntaub ntawv, cov ntaub ntawv raug khaws cia raws li nplooj ntawvCov. GAM, SGAM thiab IAM puav leej siv rau kev faib nyiaj. Thiab cov ntaub ntawv raug faib rau hauv chav ntsuas ntawm (8 nplooj ntawv) es tsis txhob ib nplooj los txhim kho kev ua haujlwm. Yog tias qhov twg tau faib los ntawm GAM tab sis tsis tau faib los ntawm SGAM lossis IAM, ces CHECKDB yuav tshaj qhia Wb 8905, thiab tom qab ntawd sim kho nws.

Koj tuaj yeem siv peb cov khoom DataNumen SQL Recovery kom rov qab tau cov ntaub ntawv los ntawm cov ntawv tsis txaus siab MDF thiab daws cov kev ua yuam kev no.

Qauv Daim Ntawv 1:

Qauv piv txwv MDF cov ntaub ntawv nyob rau qhov twg CHECKDB REPAIR_ALLOW_DATA_LOS yuav pom Wb 8905 kev ua yuam kev, tab sis TSIS TXHOB muab rov qab rau cov ntaub ntawv, thaum DataNumen SQL Recovery tuaj yeem.

SQL Server version	Corrupt MDF cov ntaub ntawv	MDF ntawv tsau los ntawm DataNumen SQL Recovery
SQL Server 2014	Yuam Kev 11.mdf ua	Yuam Kev11_fixed.mdf