What is the use of DBCC commands in sql server 2005?
This is a discussion on What is the use of DBCC commands in sql server 2005? within the Database Support forums, part of the Web Development category; What is the use of DBCC commands in sql server 2005?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
What is the use of DBCC commands in sql server 2005? 
07-25-2007, 03:36 AM
| |||
| |||
 Re: What is the use of DBCC commands in sql server 2005? 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.     |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL Server 2005 | kingmaker | Database Support | 100 | 03-22-2008 02:08 AM |
| DBCC Commands Complete List for SQL Server | vadivelanshanmugam | Database Support | 7 | 03-12-2008 09:45 PM |
| What is the difference between DELETE TABLE and TRUNCATE TABLE commands in SQL Server | oxygen | Database Support | 6 | 11-23-2007 06:17 AM |
| Server Assessment for Sql server 2005? | arjkhanna | Server Management | 3 | 10-30-2007 11:09 AM |
| What is a Linked Server in sql server 2005? | Archer | Database Support | 2 | 08-14-2007 04:24 AM |
All times are GMT -7. The time now is 05:51 AM.
