Is it possible run DBCC CHECKDB on a single partition?

Question

Is it possible to run DBCC CHECKDB on a single partition in sql server? I know we could use CHECKFILEGROUP if the partitions are on separate filegroups but what if the partitions are not on separate filegroups? Is there an option to specify the partition no with CHECKDB?

Answer 1

Nope - I never got around to writing a partition-only consistency check when I rewrote CHECKDB. CHECKFILEGROUP is your only option.

Thanks