Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the use of DBCC commands?

April 26, 2017commands dbcc

0

Posted

What is the use of DBCC commands?

1 Answer

0

Posted

DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks. E.g. DBCC CHECKDB – Ensures that tables in the db and the indexes are correctly linked. DBCC CHECKALLOC – To check that all pages in a db are correctly allocated. DBCC CHECKFILEGROUP – Checks all tables file group for any damage.