DBCC CHECKDB说明...... [英] DBCC CHECKDB Explain...

问题描述

任何人都可以详细解释一下DBCC CHECKDB。

我也到了微软网站，但我无法理解它。

所以你能解释一下吗？我以一种简单的方式..

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..

推荐答案

数据库控制台命令（DBCC）。

检查数据库（CHECKDB）（特定数据库）错误。



DBCC CHECKDB检查SQL Server数据库中的错误。

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

DBCC CHECKDB to check errors in SQL Server database.

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

现在阅读。 DBCC CHECKDB [ ^ ]

DBCC CHECKALLOC [ ^ ]

DBCC CHECKTABLE [ ^ ]



我希望你现在能理解。

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

I hope you can understand now.

这是一个DataBase控制台命令，也称为数据库一致性检查。

它用于维护数据库的完整性和一致性。

它运行以下三个



DBCC CHECKALLOC

DBCC CHECKTABLE

DBCC CHECKCATLOG



这些三个命令用于不同的目的，但所有这些命令都是通过执行DBCC CHECKDB完成的。



您可以通过以下链接获取更多信息



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

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/[^]

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)

这篇关于DBCC CHECKDB说明......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！