John Mitchell-245523 (9/13/2016)

---

I notice this is an old thread, but in case anyone reading it is in a similar position, the steps are much simpler than those recommended above:

(1) Take a transaction log backup of your database right now

(2) Restore your database from the 7am backup on to a different server (or the same server with a different database name) with no recovery

(3) Restore the log backup with recovery and stop at 4:44:59pm

(4) Copy the required data from the restored database back to the original one. Be careful of foreign key constraints and so on

(5) Schedule some transaction log backups on all your databases that aren't in Simple recovery mode. Your career will depend on not making a mistake like this again

John