Don't forget about rule #1
So I screwed up... Yes, as hard as that is for me to say. I royally screwed up (with some help from a colleague). When setting up a new live deployment of your product. ALWAYS SET UP BACKUPS FOR YOUR DB's . Yes, it seems stupid that I should even say this, but for the first time during my 8 year career, I forgot to set up backups. The product went live a bout a week before and a colleague accidentally restored our blank database backup over the production database... Lots of data loss! NOW WHAT? WHERE DO I START HOW DO I TELL THE CLIENT CAN WE RECOVER? I decided to Google How to roll back a database restore . You have to try right. No luck. I got served up countless posts about people in the same situation, all being told: "Restore your latest full backup and then restore the balance from your transaction log backup." Great... And then a few unlucky souls that ended up in the same situation with no options. Oops. So after this, I had to call the client and explain what