User Id :    Password :      New Member   Forgot Password  
Topic: What is the use of DBCC commands
Sachin Jain
30 Oct 2010 at 02:01 AM
What is the use of DBCC commands.

Re: What is the use of DBCC commands
31 Oct 2010 at 11:52 PM

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 CHECKDB - Ensures that tables in the db and the indexes are correctly linked. and 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.

Total Replies: 1
Featured Text Ad

Featured Ad