Hi Ratheesh,

If that's a prod box then you have 2 options left, either restore a copy of that db to a test environment, and run dbcc checks on that. In case if you don't have a test environment setup for this (which I think shouldn't be the case) then you need to ask some downtime from the business owners of that db coz this will be a resource intensive operation, and you don't want anything coming your way of testing.

There is an alternate option as well, wherein you can use sql virtual restore from red gate, pickup the backup of the database, restore it as a virtual db, and run consistency checks on them. It will not only save on the space, but less utilization of resources as well.Try testing it with a trial version, it would definitely do wonders for you.

The product actually is beneficial for VLDB's, as checks would be quite stressful, and if you're down with drive space...for e.g: if you have 8 TB of database (mostly in a datawarehouse scenario), and you can't physically restore the db, then you should opt for this product, it will do the stuff for you.

I hope this helps!!!

Regards,

Faisal