Aisan:

Nigba lilo DBCC Ṣayẹwo pẹlu REPAIR_ALLOW_DATA_LOSS paramita lati tunṣe ibi ipamọ data .MDF bajẹ, bii eleyi:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

o wo ifiranṣẹ aṣiṣe wọnyi:

Awọn abajade DBCC fun 'Error1'.
Tunṣe: Iwọn naa (1: 296) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Tunṣe: Iwọn naa (1: 304) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Tunṣe: Iwọn naa (1: 312) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Tunṣe: Iwọn naa (1: 328) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Tunṣe: Iwọn naa (1: 360) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Tunṣe: Iwọn naa (1: 376) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Tunṣe: Iwọn naa (1: 384) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Tunṣe: Iwọn naa (1: 400) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ).
Titunṣe: Oju-iwe naa (1: 285) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ).
Titunṣe: Oju-iwe naa (1: 287) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ).
Titunṣe: Oju-iwe naa (1: 289) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ).
Titunṣe: Oju-iwe naa (1: 291) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ).
Titunṣe: Oju-iwe naa (1: 293) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ).
Titunṣe: Oju-iwe naa (1: 368) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ).
Titunṣe: Oju-iwe naa (1: 283) ti pin lati ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597770317824 (tẹ Aimọ).
Msg 8948, Ipele 16, Ipinle 3, Laini 8
Aṣiṣe aaye data: Oju-iwe (1: 284) ti samisi pẹlu iru aṣiṣe ni oju-iwe PFS (1: 1). Ipo PFS 0x70 ti nireti 0x60.
Aṣiṣe ti tunṣe.
Msg 8948, Ipele 16, Ipinle 3, Laini 8
Aṣiṣe aaye data: Oju-iwe (1: 286) ti samisi pẹlu iru aṣiṣe ni oju-iwe PFS (1: 1). Ipo PFS 0x70 ti nireti 0x60.
Aṣiṣe ti tunṣe.
Msg 8948, Ipele 16, Ipinle 3, Laini 8
Aṣiṣe aaye data: Oju-iwe (1: 288) ti samisi pẹlu iru aṣiṣe ni oju-iwe PFS (1: 1). Ipo PFS 0x70 ti nireti 0x60.
Aṣiṣe ti tunṣe.
Msg 8948, Ipele 16, Ipinle 3, Laini 8
Aṣiṣe aaye data: Oju-iwe (1: 290) ti samisi pẹlu iru aṣiṣe ni oju-iwe PFS (1: 1). Ipo PFS 0x70 ti nireti 0x60.
Aṣiṣe ti tunṣe.
Msg 8948, Ipele 16, Ipinle 3, Laini 8
Aṣiṣe aaye data: Oju-iwe (1: 292) ti samisi pẹlu iru aṣiṣe ni oju-iwe PFS (1: 1). Ipo PFS 0x70 ti nireti 0x60.
Aṣiṣe ti tunṣe.
Msg 8948, Ipele 16, Ipinle 3, Laini 8
Aṣiṣe aaye data: Oju-iwe (1: 294) ti samisi pẹlu iru aṣiṣe ni oju-iwe PFS (1: 1). Ipo PFS 0x70 ti nireti 0x60.
Aṣiṣe ti tunṣe.
Msg 8948, Ipele 16, Ipinle 3, Laini 8
Aṣiṣe aaye data: Oju-iwe (1: 295) ti samisi pẹlu iru aṣiṣe ni oju-iwe PFS (1: 1). Ipo PFS 0x70 ti nireti 0x60.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 296) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 304) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 312) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 328) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 360) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8928, Ipele 16, Ipinle 6, Laini 8
Nkan Nkan 0, ID atọka -1, ID ipin 0, ipin ipin ID 0 (tẹ Aimọ): Oju-iwe (1: 368) ko le ṣe ilana. Wo awọn aṣiṣe miiran fun awọn alaye.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 376) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 384) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8905, Ipele 16, Ipinle 1, Laini 8
Afikun (1: 400) ninu ID ID data 39 ti samisi ipin ninu GAM, ṣugbọn ko si SGAM tabi IAM ti o fi sii.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 281475001417728 (tẹ Aimọ), ID oju-iwe (1: 376) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (70: 34).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 284) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 285) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 285) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (8074: 44).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 286) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 287) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 287) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (7620: 27).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 288) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 289) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 289) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (8053: 29).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 290) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 291) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 291) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (7098: 50).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 292) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 293) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 293) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (7098: 50).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 294) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 295) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 313) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (7220: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 328) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (6846: 34).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 368) ninu iwe ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 368) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (6: 34).
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 385) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (7074: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597764222976 (tẹ Aimọ), ID oju-iwe (1: 400) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (6818: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597769400320 (tẹ Aimọ), ID oju-iwe (1: 296) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (4044: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597769465856 (tẹ Aimọ), ID oju-iwe (1: 384) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (4076: 34).
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 283) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597770317824 (tẹ Aimọ), ID oju-iwe (1: 283) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (3374: 54).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597783752704 (tẹ Aimọ), ID oju-iwe (1: 297) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (10: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597783818240 (tẹ Aimọ), ID oju-iwe (1: 298) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (18: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597783883776 (tẹ Aimọ), ID oju-iwe (1: 299) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (42: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597783949312 (tẹ Aimọ), ID oju-iwe (1: 300) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (14: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784014848 (tẹ Aimọ), ID oju-iwe (1: 301) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (14: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784080384 (tẹ Aimọ), ID oju-iwe (1: 302) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (32: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784145920 (tẹ Aimọ), ID oju-iwe (1: 303) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (56: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784211456 (tẹ Aimọ), ID oju-iwe (1: 304) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (34: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784276992 (tẹ Aimọ), ID oju-iwe (1: 305) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (30: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784342528 (tẹ Aimọ), ID oju-iwe (1: 306) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (10: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784408064 (tẹ Aimọ), ID oju-iwe (1: 307) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (98: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784473600 (tẹ Aimọ), ID oju-iwe (1: 308) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (34: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784539136 (tẹ Aimọ), ID oju-iwe (1: 309) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (20: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784604672 (tẹ Aimọ), ID oju-iwe (1: 310) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (38: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784670208 (tẹ Aimọ), ID oju-iwe (1: 311) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (30: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597784735744 (tẹ Aimọ), ID oju-iwe (1: 312) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (32: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597787881472 (tẹ Aimọ), ID oju-iwe (1: 360) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (24: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597787947008 (tẹ Aimọ), ID oju-iwe (1: 361) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (6: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597788012544 (tẹ Aimọ), ID oju-iwe (1: 362) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (30: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597788078080 (tẹ Aimọ), ID oju-iwe (1: 363) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (60: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597788143616 (tẹ Aimọ), ID oju-iwe (1: 364) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (36: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597788209152 (tẹ Aimọ), ID oju-iwe (1: 365) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (8: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597788274688 (tẹ Aimọ), ID oju-iwe (1: 366) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (50: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597788864512 (tẹ Aimọ), ID oju-iwe (1: 367) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (24: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597788995584 (tẹ Aimọ), ID oju-iwe (1: 377) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (34: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597789061120 (tẹ Aimọ), ID oju-iwe (1: 378) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (52: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597789126656 (tẹ Aimọ), ID oju-iwe (1: 379) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (90: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597789192192 (tẹ Aimọ), ID oju-iwe (1: 380) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (34: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597789257728 (tẹ Aimọ), ID oju-iwe (1: 381) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (52: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597789323264 (tẹ Aimọ), ID oju-iwe (1: 382) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (76: 34).
Msg 8909, Ipele 16, Ipinle 1, Laini 8
Aṣiṣe tabili: ID ohun 0, ID atọka -1, ID ipin 0, ipin ipin ID 27021597789388800 (tẹ Aimọ), ID oju-iwe (1: 383) ni ID oju-iwe ti ko tọ ninu akọle oju-iwe rẹ. Oju-iwe naa ni akọle oju-iwe = (16: 34).
CHECKDB wa awọn aṣiṣe ipin 31 ati awọn aṣiṣe aitasera 44 ti ko ni nkan ṣe pẹlu eyikeyi ohunkan.
CHECKDB ti o wa titi awọn aṣiṣe ipin ipin 31 ati awọn aṣiṣe aitasera 0 ti ko ni nkan ṣe pẹlu eyikeyi ohunkan.
Tunṣe: Pq IAM fun idanimọ ohun 27, ID atọka 2, ID ipin 562949955190784, ipin ipin 562949955190784 ipin (iru data In-row), ti wa ni gige ṣaaju oju-iwe (1: 288) ati pe yoo tun kọ.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 288) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 27, ID atọka 2, ID ipin 562949955190784, ipin ipin ID 562949955190784 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Aṣiṣe ti tunṣe.
CHECKDB wa awọn aṣiṣe ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysowners' (ohun ID 27).
CHECKDB ti o wa titi awọn aṣiṣe ipin ipin 1 ati awọn aṣiṣe aitasera 0 ninu tabili 'sys.sysowners' (ohun ID 27).
Titunṣe: Oju-iwe naa (1:79) ti pin si ohun ID 34, ID atọka atọka, ID ipin 2, ID ipin 562949955649536 ipin (iru data In-row).
Tunṣe: Pq IAM fun idanimọ ohun 34, ID atọka 2, ID ipin 562949955649536, ipin ipin 562949955649536 ipin (iru data In-row), ti wa ni gige ṣaaju oju-iwe (1: 295) ati pe yoo tun kọ.
Titunṣe: Oju-iwe naa (1:80) ti pin si ohun ID 34, ID atọka atọka, ID ipin 3, ID ipin 844424932360192 ipin (iru data In-row).
Tunṣe: Pq IAM fun idanimọ ohun 34, ID atọka 3, ID ipin 844424932360192, ipin ipin 844424932360192 ipin (iru data In-row), ti wa ni gige ṣaaju oju-iwe (1: 368) ati pe yoo tun kọ.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 79) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 295) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 34, ID atọka 2, ID ipin 562949955649536, ipin ipin ID 562949955649536 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Aṣiṣe ti tunṣe.
Msg 8906, Ipele 16, Ipinle 1, Laini 8
Oju-iwe (1: 80) ninu ibi ipamọ data ID 39 ni ipin ninu SGAM (1: 3) ati PFS (1: 1), ṣugbọn a ko pin ni eyikeyi IAM. Awọn asia PFS 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
Aṣiṣe ti tunṣe.
Msg 2575, Ipele 16, Ipinle 1, Laini 8
Oju-iwe Itọka Isọka (IAM) oju-iwe (1: 368) tọka si nipasẹ itọka atẹle ti oju-iwe IAM (0: 0) ninu ID ohun 34, ID atọka 3, ID ipin 844424932360192, ipin ipin ID 844424932360192 (tẹ Ni-kana data), ṣugbọn a ko rii ni ọlọjẹ naa.
Aṣiṣe ti tunṣe.
Msg 824, Ipele 24, Ipinle 2, Laini 8
SQL Server ti ṣe awari aṣiṣe I / O ti o da lori ọgbọn ọgbọn ori: oju-iwe ti ko tọ (ti a reti 1: 261; gangan 114: 34). O waye lakoko kika iwe kan (1: 261) ninu ID data data data 39 ni aiṣedeede 0x0000000020a000 ni faili 'C: Awọn faili EtoMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Afikun awọn ifiranṣẹ ninu awọn SQL Server log log tabi log iṣẹlẹ iṣẹlẹ le pese alaye diẹ sii. Eyi jẹ ipo aṣiṣe ti o nira ti o jẹ irokeke iduroṣinṣin data ati pe o gbọdọ ṣe atunṣe lẹsẹkẹsẹ. Pari ayẹwo aitasera data ni kikun (DBCC CHECKDB). Aṣiṣe yii le fa nipasẹ ọpọlọpọ awọn ifosiwewe; fun alaye siwaju sii, wo SQL Server Awọn iwe lori ayelujara.
Msg 824, Ipele 24, Ipinle 2, Laini 8
SQL Server ti ṣe awari aṣiṣe I / O ti o da lori ọgbọn ọgbọn kan: oju-iwe ti ko tọ (ti a reti 1: 369; gangan 40: 60). O waye lakoko kika iwe kan (1: 369) ni ID data data data 39 ni aiṣedeede 0x000000002e2000 ni faili 'C: Awọn faili EtoMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. Afikun awọn ifiranṣẹ ninu awọn SQL Server log log tabi log iṣẹlẹ iṣẹlẹ le pese alaye diẹ sii. Eyi jẹ ipo aṣiṣe ti o nira ti o jẹ irokeke iduroṣinṣin data ati pe o gbọdọ ṣe atunṣe lẹsẹkẹsẹ. Pari ayẹwo aitasera data ni kikun (DBCC CHECKDB). Aṣiṣe yii le fa nipasẹ ọpọlọpọ awọn ifosiwewe; fun alaye siwaju sii, wo SQL Server Awọn iwe lori ayelujara.

ibiti ‘Error1’ ti jẹ orukọ ibi ipamọ data MDF bajẹ.

Arabinrin 8905 tọkasi iye ti a pin si GAM, ṣugbọn ko si SGAM tabi IAM ti ya sọtọ. Eyi jẹ aṣiṣe ipin.

Iboju ti ifiranṣẹ aṣiṣe:

Kongẹ Apejuwe:

Ninu iwe data MDF, awọn data ti wa ni fipamọ bi ojúewé. GAM, SGAM ati IAM gbogbo wọn lo fun awọn ipin. Ati pe a pin awọn data ni apakan ti iye (awọn oju-iwe 8) dipo oju-iwe kan lati mu iṣẹ naa dara. Ti iwọn ba pin nipasẹ GAM ṣugbọn ko ṣe ipin nipasẹ SGAM tabi IAM, lẹhinna CHECKDB yoo ṣe ijabọ Arabinrin 8905, ati lẹhinna gbiyanju lati ṣatunṣe rẹ.

O le lo ọja wa DataNumen SQL Recovery lati gba data pada lati faili MDF ibajẹ ati yanju aṣiṣe yii.

Ayẹwo Faili 1:

Ayẹwo ba awọn faili MDF lori eyiti Ṣayẹwo REPAIR_ALLOW_DATA_LOSS yoo ri Arabinrin 8905 aṣiṣe, ṣugbọn KO ni anfani lati ṣe igbasilẹ ibi ipamọ data, lakoko DataNumen SQL Recovery le.

SQL Server version Ibaje MDF faili MDF faili ti o wa titi nipasẹ DataNumen SQL Recovery
SQL Server 2014 Aṣiṣe11.mdf Aṣiṣe11_fixed.mdf