CheckDB ko CheckTable Fails

Alamar:

Lokacin amfani da DBCC CheckDB ko CheckTable don gyara ɓatattun bayanan .MDF, sai ka ga saƙon kuskure mai zuwa:
Ba a yi nasarar ba: (- #######) An aiwatar da tambayar "DBCC CHECKDB (xxxx) TARE DA NO_INFOMSGS" ya gaza tare da kuskuren mai zuwa: “xxxx”.

or

An gano kuskuren I / O (mummunan shafi ID) yayin karantawa a biya diyya 0x ###### a cikin fayil 'xxxx.mdf'.

inda 'xxxx.mdf' shine sunan fayil ɗin MDF da ake samun dama.

Daidaitaccen Bayani:

CheckDB da CheckTable suna iya gyara bayanan MDF kawai tare da ƙananan lalata. Don ɓarna mai tsanani, kuna buƙatar amfani da samfurinmu DataNumen SQL Recovery don dawo da bayanan.

References:

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