7 responses

  1. Kelloggsville
    May 17, 2011

    And how many times I have been told that the database doesn’t need a backup because the data can be recreated from it’s source. Oh yeah?! And what are you going to put the source data into because you had no backup (of structure) sigh. Hear ‘it doesn’t need to be backed up’ as I am not prepared to think about or pay for backup strategy but I expect the DBA to bs able to rebuild it when I break it. Garrrr

    • JeffS
      JeffS
      May 17, 2011

      What goes unsaid is the amount of time it takes even to stage an empty database, dump all the data back in, rebuild indexes, stats, jobs, privs…especially when that data is spread out to multiple sources. You need a recovery SLA that documents the expectations so you can tailor the backup schemes.

      On the flip-side, do you back up a DW that’s terabytes large and can be re-built from existing production instance?

      Not prepared to pay for backup strategy…like buying a luxury automobile, but not willing to buy premium petrol or regular service visits!

  2. Gary
    May 17, 2011

    Couple of thoughts
    Firstly, dev and test databases, by their nature, are more likely to corrupted than prod. They are running software that hasn’t been fully tested. They are also likely to run on a less resilient hardware platform.
    Secondly, demo databases (and, in some cases, test) can be much less volatile. You may need a backup once a week or once a month.
    These databases also have a lower uptime requirement and often don’t require point in time recovery. Cold backups, or exports, might be sufficient.

    Finally, the bit about not needing all your teeth reminds me of a joke. Mum catches teenage son engaged in a certain activity and tells him that if he carries on, he’ll go blind. After a few moments thought he says, “Maybe I carry on just until I need glasses”.

    • JeffS
      JeffS
      May 17, 2011

      I approve of your joke :)

  3. Laurent Schneider
    May 20, 2011

    My 2 cents as a dba :

    PROD : online backup
    TEST : weekly cold backup in noarchivelog OR weekly clone from production

    Unless specified differently by the project

    • JeffS
      JeffS
      May 20, 2011

      I like that, unless specified otherwise, Test gets backed up once a week. Have you ever been told NOT to back something up, and then later be asked to help recover lost data?

Leave a Reply

 

 

 

Back to top
mobile desktop