• Lots of copies..This is all for 1 database...

    production application:

    Main server:

    primary copy of the database

    backup image from previous night

    DR/HA server:

    copy of the database

    UAT server:

    2x copy of the database

    reports systems:

    vm report server:

    copy of the database

    3x backups

    physical report server:

    copy of the database

    1x backup

    vm report server (test system):

    copy of the database

    1x backup

    backup servers:

    entire VM report server backed up

    entire physical report server backed up

    entire vm test system backed up

    application servers back up directly to tape so not included in backup servers.

    in all 21 copies of the database plus a partial (annonymised) copy on my workstation that I sometimes use for dev.

    I think it's about time we reviewed our backup stratergy...

    Ben

    ^ Thats me!

    ----------------------------------------
    01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
    ----------------------------------------