User Id :
Stay Signed In
Write For Us
Topic: What is the use of DBCC commands
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
© 2017-2018 DotNetLogix. All rights reserved.
Privacy and Policy