corruption - SQL Server CE SDF file corrupt. Fixing schema and understanding the repair log file -
i have received corrupt .sdf file client. used sqlceengine.engine method allow me repair point can connect database file , view schema. has recovered of data. although main table have called tablea empty. it created log file seems printing out rows not recover... interesting point "invalid number of columns". 2 years ago schema update pushed out adding 3 new columns. when checked schema on recovered .sdf file missing these 3 columns. assuming schema has corrupted , recovery method trying reinsert rows doesn't match table schema more. find odd cannot recover these 3 columns. can explain more going on log file? i guessing there no way of adding missing columns first , repairing it, rows match possible recovering more data table? many thanks. the log file contains reference tablea, , there 2 types of entry. snippet of log file: block page not found - pwsztable: tablea, idpage: 1465 block page not found - pwsztable: tablea, idpage: 1465 invalid number of...