Hi Friends.........
What is the use of DBCC commands? Can you give me some DBCC command options?
Thanks.........
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Nov 28, 2011, 9:53 PM
DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, and validation task and status checksDBCC CHECKDB - To ensure 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
Refer
http://www.novicksoftware.com/tipsandtricks/tip-sql-dbcc-help.htmThanks
Vikas MishraPosted Nov 29, 2011, 12:23 PM
Kunal NaikPosted Nov 28, 2011, 11:16 PM
refer below links,
http://msdn.microsoft.com/en-us/library/ms188796.aspx
http://msdn.microsoft.com/en-us/library/ms176064.aspx
http://www.sql-server-performance.com/2006/dbcc-commands/
http://www.windowsitpro.com/article/john-savills-windows-faqs/what-are-all-the-dbcc-commands-for-sql-server-
may be it helps you.