Colleague Michael Corey shared an interesting story in his post Have you firedrilled your Oracle or Microsoft SQL Database Backup? recently. He tells an all-too-common anecdote about organizations that assume that their back up is working, but have never tested it.
Last summer, we held our breath when the CW Consulting Group offices were struck by lightning and two computers were fried (along with our phone system).
Two things we learned:
- surge protectors can’t stand up to lightning
- back ups can’t be ignored.
We have a new backup system since that electrical storm, and every night at 10 pm I can hear the back up begin to work. This gave me peace of mind until I read Michael’s post. When is the last time you looked at the back up to make sure it is copying the right data, that the back up is retrievable, and the files are not corrupt?
Note to IT: Check to make sure it is backing up correctly.
What about you? Has your back up system been tested?
Check out Michael’s blog here: http://michaelcorey.ntirety.com/ and learn everything you need to know about database administration. Michael knows his stuff. He is one of the best in the field.