george sibbald (7/15/2013)
check also the minimum repair level checkdb reports.If its a non-clustered index that turns out to be corrupted you may be able to just drop and recreate it.
Do you have a clean backup? almost always your best way out of a corruption.
Unfortunately no recent clean backup 🙁 and ive been i cannot repair as its seriously corrupt
I dont know if its a non-clustered index or table that is corrupted. My strategy as i stated above was to create a new db and script all the objects that are 'good' and not the 'bad' ones. This is why im trying to ascertain the corrupt objects.