Unanswered: Data recovery from failed publication - URGENT
I am using merge publication to synchronise the data from 150 field force sales reps (HPC Jornada 720 - windows CE, SQL CE) to main SQL server in Office (2000). Sales reps synchronise the data once a week. Today my main server crashes & I have to rebuild the database & so publication. Still there is a data of one week on sales reps HPC, how to restore data from all individuals in a new database.