Uphawu:
Xa usebenzisa DBCC CHECKDB kunye REPAIR_ALLOW_DATA_LOSS iparameter ukulungisa idatabase ye.MDF eyonakeleyo, ngolu hlobo:
I-DBCC CHECKDB(xxxx, 'REPAIR_ALLOW_DATA_LOSS')
ubona lo myalezo wemposiso ulandelayo:
Nksg 5028, iNqanaba 16, i-State 4, i-Line 4
Inkqubo ayikwazanga ukwenza isebenze ngokwaneleyo yesiseko sedatha ukuze iphinde iphinde yakhiwe ilog.
Iziphumo zeDBCC ze'xxxx'.
I-CHECKDB ifumene iimpazamo ezi-0 zolwabiwo kunye neempazamo ezi-0 ezihambelanayo kwiziko ledatha 'xxxx'.
Nksg 7909, iNqanaba 20, i-State 1, i-Line 4
Ulungiso lwemo engxamisekileyo aluphumelelanga.Kufuneka ubuyisele kwi-backup.
apho 'xxxx' ligama lesiseko sedatha esonakeleyo se-MDF elungiswayo.
UMsg 5028 Impazamo ayiyompazamo yolwabiwo okanye impazamo yokungaguquguquki.
Nakuba UMsg 7909 yimpazamo enkulu enokuthi yenzeke kwiimeko ezininzi nanini na SQL Server cinga ukuba i-database ingaphaya kokubuyisela.
Umfanekiso weskrini wemposiso:
Ingcaciso echanekileyo:
Umyalezo wemposiso (UMsg 5028) ibonakala inxulumene nefayile yeLOG. Nangona kunjalo, le yingxelo engeyiyo. Eyona ngxaki isabangelwa lurhwaphilizo lwedathabheyisi ye-MDF.
Ungasebenzisa imveliso yethu DataNumen SQL Recovery ukubuyisela idatha kwifayile ye-MDF eyonakele kwaye uyisombulule le mpazamo.
Iifayili zesampulu:
Isampulu yeefayile zeMDF ezonakeleyo eziya kubangela i UMsg 5028 imposiso:
SQL Server Inguqulelo | Ifayile ye-MDF eyonakele | Ifayile ye-MDF ilungiswe ngu DataNumen SQL Recovery |
SQL Server 2014 | Imposiso3.mdf | Imposiso3_ilungisiwe.mdf |