Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is the use of DBCC commands?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is the use of DBCC commands?
1 Answer(s)      3 years and 10 months ago
Posted in : SQL


What is the use of DBCC commands?


Advertisement
View Answers

November 18, 2010 at 5:16 PM


Hi,

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.

DBCC command options (Database consistency check) -

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 SQLPERF - It gives report on current usage of transaction log in percentage.

DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

Thanks,



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com