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
----------------------------------------