DBCC CHECKDB Explain...

Question

0.00/5 (No votes)

See more:

Can any one explain about DBCC CHECKDB in detail.
I got to the Microsoft site also but I was not able to understand it there.
So can you explain me in a simple way..

Posted 25-Dec-14 23:43pm

K.Y.S.Phaneendra

Add a Solution

3 solutions

Solution 2

Database Console Command(DBCC).
Check database(CHECKDB)(a particular database) for Errors.

DBCC CHECKDB to check errors in SQL Server database.

SQL

-- Check the current database.
DBCC CHECKDB;
GO
-- Check the AdventureWorks2012 database without nonclustered indexes.
DBCC CHECKDB (AdventureWorks2012, NOINDEX);
GO

read now. DBCC CHECKDB[^]
DBCC CHECKALLOC[^]
DBCC CHECKTABLE[^]

I hope you can understand now.

Posted 26-Dec-14 1:20am

/\jmot

Solution 1

SQL

This command is used to reset the identity fields on the table.whenever you delete rows,the identity column will not reset by default.

To reset the identity column,Run the following command:

DBCC CHECKIDENT ('[TestTable]', RESEED, 0)

Posted 25-Dec-14 23:59pm

Arjsrya

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

K.Y.S.Phaneendra · Accepted Answer · 2014-12-29T19:26:00

It is a DataBase Console Command that is also called DataBase Consistency Check.
It is used to maintain the integrity and consistency of the database.
It runns three of the following

DBCC CHECKALLOC
DBCC CHECKTABLE
DBCC CHECKCATLOG

These three commands are used for different purposes but all of them are done by executing DBCC CHECKDB.

You can go the following link for better information

http://www.mssqltips.com/sqlservertip/2399/minimize-performance-impact-of-sql-server-dbcc-checkdb/[^]

DBCC CHECKDB Explain...

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

DBCC CHECKDB Explain...

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us