1. Update resume 2. Update Linkedin 3. Contact head hunters 4. Restore database with different name or to different server 5. Copy table from restored database into prod database 6. Add any dependent objects such as foreign keys 7.
I couldn't stop thinking about this last night and came up with: 1. (Minor point but c'mon) A "critical highly transactional table" has been dropped yet the application is still running....? 2. You can't just take an earlier backup since you'd lose data. You'd want to do a point in time restore, if possible. 3. To get restored the quickest, wouldn't you want to consider a Filegroup restore. It may be too messy depending on what else is in the filegroup and what data may have changed. 4. Perhaps the most important of all, find the person who recently left the company and blame the whole thing on them! Mention that you had warned people that this was gonna happen and that to prevent it you'll need additional authority and a MUCH larger budget!!!
=============================================================================== “Everyone wants a better life: very few of us want to be better people.” -Alain de Botton