GilaMonster (7/29/2014)
I said nothing implying you should have repaired...See if you can get some automated restore tests set up. Restore backups on another server, run CheckDB. Off the prod server means it doesn't matter how long they take, does mean you will know if your backups are good.
See if there's any way you can archive older data into tables on another filegroup or another database entirely. Generally with a DB like that, the active portion is tiny compared to the entire DB.
Ah I should have mentioned we had multiple 'solutions' occurring in parallel and repair_allow_data_loss was one of them as an absolute last resort.
And yes, I managed to archive one table (yippee) into another database last year but their biggest table, an audit table, taking 300GB out of the 1TB, cannot be touched according to the business, they want all history in there..and accessible if needed..ugh.
And yes (again), doing more frequent checkdbs is definitely being looked at..thanks again everyone.