Ronald Cartmale (1/5/2010)
I could not agree more with the editorial and have always sort to ensure that my company’s data is protected by the best possible practice but when you work for a company whose only interest in backups is when the worst happens, then like in the film Heart Break Ridge you have to adapt and improvise.
I am constantly struggling to achieve even simple model backups because of the lack of disk storage space let alone move over to more secure complex models, and due to performance issues I am limited to doing one backup per day.
It is frightening to think that there are companies like this, but I am sure we are not alone as with everything it boils down to cost and like many many people they know they should have life, even property insurance (see some of the cases of UK flood victims) but just can’t justify the cost at the time.
Sadly, Penny wise, pound foolish. ;-)
My wife and I used to pay renters insurance when we lived in the city. People scoffed at us until the day we were broken into. They cleaned us out, but we were able to replace most of it because of the insurance.
I also remember having a database go corrupt, fluke thing, but we had good backups and log backups and did a point in time recovery to about a minute before the corruption occurred. We were heroes that day and just because of something incredibly fundamental and stupid easy, good, tested, backups.
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore RooseveltThe Scary DBA
Author of: SQL Server Query Performance Tuning
and SQL Server Execution Plans
Product Evangelist for Red Gate Software