Home Dashboard Directory Help
Search

DBCC CHECKDB omit tables option by Greg Low - Australia


Status: 

Closed
 as Won't Fix Help for as Won't Fix


3
0
Sign in
to vote
Type: Suggestion
ID: 611164
Opened: 10/6/2010 3:22:13 PM
Access Restriction: Public
0
Workaround(s)
view

Description

For VLDBs, it would be useful to have an option to specify which tables to omit when running DBCC CHECKDB.
Details
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.

Regards,

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

Thanks,
Ryan Stonecipher
Sign in to post a workaround.