Simple recovery model...

CRAP!

ok, no page restore then.

My options just got limited.

option 1, restore full, restore diffs until i find the corruption, then reload in missing data. This is the long option.

option 2, create snapshot, run repair allow data loss, hope it's limited to the 6900 rows identified in the checkdb output, reload those rows later from an older backups of the source system.

I'm leaning toward option 2, then falling back to option 1 if needed.

thoughts?