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

  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 :

  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