Last night I was posting a few links of pictures on a QA
site that I often visit when I realized that my house address was clearly
posted on my website. While I normally am not huge on my personal privacy; as I
clearly post picture of my house and family on the open internet without a
care. But I thought I was paying attention to not post my address up there too.
But there is was in black and white. So like a good person I edited out my
address. This is where it all went wrong. Apparently my TinyMCE did not like
the horrible HTML that was also in my post. So it cleaned it up for me and removed
all of the good information about me house that I was trying to save all along.
Now what
How can I get this back? Epiphany, I got it! I
keep a history of all my posts so if I ever screw one up I can go back, Wiki
style. Nope. That’s only for blog entries, not image galleries. Time to restore
the database to 5 minutes ago. First. Lets take a clean backup just in case it
goes wrong.
My backup plan
Currently I take a full backup 3 times a week. I also ship
transaction logs. I can do a point in time to 5 minutes ago with no problem,
right? Wrong.
The Bad
It seems I never changed my backup plan to coincide with the
removal of a drive where my backups were pointed. My last full backup was
November 21st 2011. This hurts.
The Good
I have a nightly job that cleans up old transaction logs
from older than 4 days ago. This nightly job keeps running like a champ. This
is also where I shake my head. This is bad too.
In the wash
Left with a backup from November, and 4 days of transaction
logs I quickly find that I’m not able to do a restore. Time to restore into
another database and copy the missing information over to the working database.
Thankfully this is old information and I have it captured in my existing
backup. I now have another clean backup and 4 days to get my nightly backups
running, before I’m left in the same position of not having all my logs.
Verified backups are important!
