-- 1. Row count parity with known good backup (or approximate) SELECT COUNT(*) FROM suspect_table; -- 2. Foreign key sanity (orphaned rows after repair) SELECT fk.name, OBJECT_NAME(fk.parent_object_id) FROM sys.foreign_keys fk WHERE NOT EXISTS (SELECT 1 FROM sys.tables t WHERE t.object_id = fk.referenced_object_id);