javascript
Brief description  about Online courses   join in Online courses
View Diwakar  reddy 's Profile

What is the use of DBCC commands?

hello sir
i want to know what all uses of DBCC commands?
Asked by Diwakar reddy | Sep 3, 2010 |  Reply now
Replies (1)
View Teacher Sql 's Profile
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.
Sep 3, 2010