Tohu:

A, no te whakamahi DBCC CHECKDB mā te REPAIR_ALLOW_DATA_LOSS tawhā hei whakapai ake i te papaanga raraunga .MDF pirau, penei:

DBCC CHECKDB (xxxx, 'REPAIR_ALLOW_DATA_LOSS')

ka kite koe i nga korero hapa e whai ake nei:

Msg 824, Taumata 24, State 2, Raina 2
SQL Server i kitea he raru I / O e hangai ana ki te riterite o te whaarangi: he he pageid (e manakohia ana 1: 143; tino 0: 9). I puta i te wa o te panui o te whaarangi (1: 143) i roto i te ID paparanga 39 i te paunga 0x0000000011e000 kei roto i te konae 'C: Kaupapa PepaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. He kupu taapiri kei roto i te SQL Server rākau hapa, takahanga takahanga ranei o te punaha ka nui ake nga korero hei whakaatu He mate hapa kino tenei e whakawehi ana i te pono o te putunga raraunga a me whakatika tonu. Whakaotihia he taipitopito tuuturu raupaparorohiko (DBCC CHECKDB). He maha nga mea i puta mai ai tenei he; mo etahi atu korero, tirohia SQL Server Pukapuka A-Ipurangi.
Msg 3313, Taumata 21, State 1, Raina 2
I te whakahoutanga o te mahi kua whakauruhia ki te papaarangi 'Hapa1', i puta he raru i te ID rekoata rakau (135: 752: 2). I te nuinga o te waa, ko te ngoikoretanga motuhake i hainahia i mua he hapa i roto i te ratonga Rangahau Takahanga Windows Whakaorangia te papaarangi mai i te taapiri katoa, te whakatika ranei i te papaarangi.
Msg 3414, Taumata 21, State 1, Raina 2
I puta he raru i te wa e whakaora ana, ka aukati i te paatata raraunga 'Hapa1' (39: 0) mai i te restarting. Whakamatauhia nga hapa whakaora me te whakatika, me whakahoki mai ranei i tetahi taapiri pai e mohiotia ana. Mena kaore i te whakatikahia nga hapa kaore ranei e tumanakohia, whakapā atu ki te Tautoko Hangarau.
Msg 824, Taumata 24, State 2, Raina 2
SQL Server i kitea he raru I / O e hangai ana ki te riterite o te whaarangi: he whaarangi whaarangi (e manakohia ana 1: 160; tino 0:41). I puta i te wa o te panui o te whaarangi (1: 160) i roto i te ID papanga 39 i te paunga 0x00000000140000 kei roto i te konae 'C: Kaupapa PepaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. He kupu taapiri kei roto i te SQL Server rākau hapa, takahanga takahanga ranei o te punaha ka nui ake nga korero hei whakaatu He mate hapa kino tenei e whakawehi ana i te pono o te putunga raraunga a me whakatika tonu. Whakaotihia he taipitopito tuuturu raupaparorohiko (DBCC CHECKDB). He maha nga mea i puta mai ai tenei he; mo etahi atu korero, tirohia SQL Server Pukapuka A-Ipurangi.
Msg 824, Taumata 24, State 2, Raina 4
SQL Server i kitea he raru I / O e hangai ana ki te riterite o te whaarangi: he whaarangi whaarangi (e manakohia ana 1: 160; tino 0:41). I puta i te wa o te panui o te whaarangi (1: 160) i roto i te ID papanga 39 i te paunga 0x00000000140000 kei roto i te konae 'C: Kaupapa PepaMicrosoft SQL ServerMSSQL12.SQL2014MSSQLDATAError1.mdf '. He kupu taapiri kei roto i te SQL Server rākau hapa, takahanga takahanga ranei o te punaha ka nui ake nga korero hei whakaatu He mate hapa kino tenei e whakawehi ana i te pono o te putunga raraunga a me whakatika tonu. Whakaotihia he taipitopito tuuturu raupaparorohiko (DBCC CHECKDB). He maha nga mea i puta mai ai tenei he; mo etahi atu korero, tirohia SQL Server Pukapuka A-Ipurangi.

kei reira te 'Hapa1' te ingoa o te putunga korero MDF kino e mahia ana.

Msg 3313 tohu e kore e taea te mahi roko.

Whakaahuamata o te hapa hapa:

Whakamarama Tino:

Ka kore e taea e te CHECKDB te mahi takiuru, ka ripoatahia te hapa hapa Msg 3313 ka ngana ki te whakatika i nga hapa. Mena kaore e taea te whakatika i te he, katahi ka kore te whakaora ka nui ake nga he, penei i te Msg 3414 me Msg 824.

Ka taea e koe te whakamahi i ta maatau hua DataNumen SQL Recovery ki te whakahoki mai i nga raraunga mai i te konae MDF kino ka whakatau i tenei he.

Kōnae Tauira:

Hei tauira, he kino nga konae MDF ka mate te Msg 3313 hapa:

SQL Server putanga Kōnae MDF pirau Ko te konae MDF na DataNumen SQL Recovery
SQL Server 2014 Hapa9.mdf Hapa9_fixed.mdf

Tohutoro: