DBCC CHECKCATALOG performs various consistency tests between system metadata tables. If you run DBCC CHECKDB, you do not need to run DBCC CHECKCATALOG. For details of DBCC CHECKDB, please refer to “DBCC CHECKDB Command On SQL Server“.

You can do this operation on the database by using the following command. You should write your database name at the place where the test is written.

As an important detail, this command cannot run in the tempdb database and the consistency of the filestream data is not checked with this command. You can find information about File Stream in my article “What is File Stream On SQL Server“.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *