I'm on SQL2005, and I've let too many days go by, so I can't restore from a backup before this error started occurring:
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1685633098) of row (object_id=1701633155) in sys.objects has a matching row (object_id=1685633098) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'healthdb’
I've read Paul Randal's blog about the 3853 error, where he deletes records to correct the problem.
I logged into the DAC and could not find a sys.objects rec that had parent_object_id= 1685633098 and object_id=1701633155.
If my only choice is to create a new db and extract the data from the corrupted db, do I use the import and export wizard to export the data to a flat file, and then import the data into the new db?
Thanks for any help!