CheckDB kana CheckTable Yakundikana

Chiratidzo:

Paunenge uchishandisa DBCC CheckDB kana CheckTable kugadzirisa yakaora .MDF dhatabhesi, unoona inotevera mhosho meseji:
Zvakundikana:(-#######) Kuita mubvunzo “DBCC CHECKDB(xxxx) WITH NO_INFOMSGS” kwatadza nekukanganisa kunotevera: “xxxx”.

or

I/O kukanganisa (yakaipa peji ID) yaonekwa panguva yekuverenga pa offset 0x####### mufaira'xxxx.mdf'.

apo 'xxxx.mdf' izita reMDF faira riri kuwanikwa.

Tsanangudzo Yakananga:

CheckDB uye CheckTable inogona chete kugadzirisa MDF dhatabhesi nehuori hudiki. Nehuwori hwakanyanya, unofanirwa kushandisa chigadzirwa chedu DataNumen SQL Recovery kudzoreredza iyo data.

References:

• https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checktable-transact-sql?view=sql-server-ver15