How do I run DBCC CHECKCB commands to repair SQL MDF files?RSS

• • Reply
  Stella Malon

  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? 

• • Reply
  Nan Yu

  All-Star

  18735 Points

  3785 Posts

  Microsoft

  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 :

  DBCC CHECKDB ('DatabaseName')   

  You can also execute the following operations sequentially:

  • Running DBCC CHECKALLOC command in the database.
  • Running DBCC CHECKCATALOG command in the database.
  • Running DBCC CHECKTABLE on 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 storing VARBINARY (max) data using FILESTREAM in the file system.
  • Authenticating the Service Broker data in the database.

  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

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.