We discovered recently a bunch of missing projects and narrowed it down to an accidental deletion by a user. We only discovered it today but the deletions were done more than 10 days ago so unfortunately I can't just overwrite the database with a backup or we lose that last 10 days worth of work. The good news is our backup systems seem to be doing their job correctly and I am restoring both the SQL database snapshot from before the deletion and the Factory Database files on that date to a temporary server. 

I guess my question is: Has anyone restored projects from backups before and want to share any "DOs or DONTs" that I should look out for?

My current plan for restoring the SQL data is to:

1) Get the LinkID of the missing project from the restored database's Projects Table

2) Insert that item back into the Main database

3) For each table that has a "LinkIDProject", insert the data from the restored database into the live database (filtered on the projectId)

The Factory files I am just going to drop in place.

Anything I am missing?