You can also execute the following operations sequentially:
RunningDBCC CHECKALLOCcommand in the database.
RunningDBCC CHECKCATALOGcommand in the database.
RunningDBCC CHECKTABLEon each view and table in the database.
Authenticating the content of each indexed view available in the database.
Authenticating link-level constancy among table metadata, file system directories, and files when storingVARBINARY(max) data usingFILESTREAMin the file system.
Authenticating the Service Broker data in the database.
None
0 Points
1 Post
How do I run DBCC CHECKCB commands to repair SQL MDF files?
Apr 02, 2019 12:26 PM|Stella Malon|LINK
Can anyone tell how do I run DBCC CHECKDB command to repair SQL server MDF file data?
All-Star
18815 Points
3831 Posts
Re: How do I run DBCC CHECKCB commands to repair SQL MDF files?
Apr 03, 2019 02:26 AM|Nan Yu|LINK
Hi Stella Malon ,
The basic syntax is :
You can also execute the following operations sequentially:
Reference :
https://dzone.com/articles/how-to-repair-mdf-file-in-sql-server-database
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-2017
Best Regards,
Nan Yu