Paunenge uchishandisa Microsoft SQL Server kubatanidza kana kuwana yakaora MDF dhatabhesi faira, unogona kusangana neakasiyana mameseji ekukanganisa anogona kuvhiringa. Pazasi, isu tichanyora zvese zvikanganiso, zvakarongwa ne frequency. Pachikanganiso chega chega, tinotsanangura zviratidzo zvayo, tsanangura chikonzero chaicho, uye nekupa sampuli mafaira pamwe chete nemafaira akagadziriswa DataNumen SQL Recovery. Izvi zvichakubatsira kuti unzwisise zviri nani zvikanganiso izvi. Cherechedza 'xxx.MDF' ichamiririra zita rehuori hwako SQL Server MDF database file.
Maererano ne SQL Server kana CHECKDB mameseji ekukanganisa, kune marudzi matatu ekukanganisa:
-
- Kukanganisa kwekugoverwa: Isu tinoziva iyo data muMDF & NDF mafaera akagoverwa se mapeji. Uye kune mamwe mapeji akakosha anoshandiswa pakugovera manejimendi, sezvinotevera:
Peji Type | tsananguro |
GAM Peji | Chengetedza ruzivo rwemepu yepasirese (GAM). |
Peji yeSGAM | Chitoro chakagovaniswa mepu yepasirese yekugovera (SGAM) ruzivo. |
IAM Peji | Chengetedza indekisi yekugovera mepu(IAM) ruzivo. |
PFS Peji | Chengetedza PFS yekugovera ruzivo. |
Kana rimwe remapeji ekugoverwa ari pamusoro ane zvikanganiso, kana data rinotungamirirwa nemapeji ekugovera aya risingaenderane neruzivo rwekugovera, ipapo SQL Server kana CHECKDB ichataura zvikanganiso zvekugovera.
- Kusawirirana kukanganisa: For mapeji ayo anoshandiswa kuchengeta data, kusanganisira iwo data mapeji uye index mapeji, kana SQL Server kana CHECKDB tsvaga chero kusawirirana pakati pezviri mukati pejiji uye cheki, ivo vanozotaura kusawirirana kukanganisa.
- Zvimwe zvikanganiso zvese: Panogona kunge paine kumwe kukanganisa kusingawire muzvikamu zviviri zviri pamusoro.
- xxxx.mdf harisi rekutanga dhatabhesi faira. (Microsoft SQL Server, Kukanganisa: 5171)
- Musoro wefaira re'xxxx.mdf' hausi musoro wefaira wedatabase unoshanda. Iyo FILE SIZE pfuma haina kururama.(Microsoft SQL Server, Kukanganisa:5172)
- SQL Server yakaona inonzwisisika-inoenderana-yakavakirwa I/O kukanganisa: isiriyo checksum
- SQL Server yaona kukanganisa kunoenderana-kwakavakirwa I/O kukanganisa: peji rakabvaruka
- Iwe unodzima mamwe marekodhi kana mamwe matafura mudhatabhesi nekukanganisa.
SQL Server ine mudziyo wakavakirwa-mukati unonzi DBCC, ine CHECKDB uye CHECKTABLE sarudzo dzinogona kubatsira kugadzirisa yakaora MDF database. Nekudaro, kune yakanyanya kukuvadzwa MDB database mafaera, DBCC CHECKDB uye CHECKTABLE zvichakundikanawo.
Consistency kukanganisa kwakataurwa neCHECKDB:
- SQL Server yakaona inonzwisisika-inoenderana-yakavakirwa I/O kukanganisa: isiriyo checksum
- Row mu sys.xxx haina mutsara unoenderana mu sys.xxx.
- Tafura kukanganisa: Object ID ##, index ID ## ichavakwa patsva.
- Iyi indekisi yetafura yehurongwa haigone kugadzirwa patsva.
- Object ID ##, index ID ##, partition ID ##, alloc unit ID ## (type Unknown), peji ID (##:560) ine peji ID isiriyo mumusoro wepeji.
Mhosho dzekugovera dzakataurwa neCHECKDB:
- Iyo Index Allocation Mepu (IAM) Peji inonongedzwa neInotevera Pointer yeIAM Peji
- Kuwedzera (##:##) mudatabase ID ## yakanyorwa yakagoverwa muGAM, asi hapana SGAM kana IAM yazvipa.
Zvimwe zvikanganiso zvese zvataurwa neCHECKDB:
- Zvakundikana:(-#######) Kuita mubvunzo “DBCC CHECKDB(xxxx) WITH NO_INFOMSGS” kwatadza nekukanganisa kunotevera: “xxxx”.
- I/O kukanganisa (yakaipa peji ID) yaonekwa panguva yekuverenga pa offset 0x####### mufaira'xxxx.mdf'.
- Sisitimu haina kukwanisa kumisa Zvakakwana zveDatabase yekuvakazve Iyo Log
- Kurasikirwa Kwedata PaKugadzirisa NeCHECKDB
- Faira rinoita kunge rakadzikiswa neiyo inoshanda sisitimu.
- Panguva yekudzokorodza kushanda kwakanyorwa mudhatabhesi 'xxxx', kukanganisa kwakaitika parekodhi rekodhi ID.