What is the minimum level of DBCC CHECKDB needed to check full-text indexes?

0 votes

1 answer

73 views

sql-server sql-server-2019 full-text-search corruption dbcc-checkdb

                          I have a database containing an unreasonably large full-text index. DBCC CHECKDB WITH PHYSICAL_ONLY takes about 25 minutes on this database, but DBCC CHECKDB WITH DATA_PURITY, EXTENDED_LOGICAL_CHECKS takes about 2 hours longer. This suggests to me that PHYSICAL_ONLY skips full-text indexes.

Am I correct? What parameters need to be passed to CHECKDB to have it check full-text indexes?

Asked by J. Mini (1237 rep)

Jul 26, 2024, 02:44 PM
Last activity: Aug 9, 2024, 02:22 PM

What is the minimum level of DBCC CHECKDB needed to check full-text indexes?

Related Questions