DBCC CHECKDB omit tables option - by Greg Low - Australia

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 611164 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/6/2010 3:22:13 PM
Access Restriction Public


For VLDBs, it would be useful to have an option to specify which tables to omit when running DBCC CHECKDB.
Sign in to post a comment.
Posted by Greg Low - Australia on 6/22/2012 at 6:18 PM
Hi Ryan,

While it could be a workaround, it's not a great one. Many larger customers have a large number of tables but only a few large tables. What they want to be able to do is to check everything in the database except those one or two large tables. The workaround in this situation is quite ugly.


Posted by Microsoft on 12/19/2011 at 9:51 AM
Thanks for your suggestion. At this time we are not going to implement the option you've requested. A script that does multiple CHCEKTABLE operations on a user-created database snapshot, or using DBCC CHECKFILEGROUP for the tables you're interested in is a reliable and, in our option, non-onerous workaround.

Ryan Stonecipher