Friday, 20. October 2017., 14:00
Backup\\\'s added value is zero, or even negative because backing up requires resources (disks, tapes, maintenance, electrical energy,...), so it represents an expense. Can the value of the backup be increased to the levels to make it profitable?
Classical backup is a real estate. There is nothing we can do with it. If we want to verify it, a test system has to be set-up and data has to be restored which requires time and other resources.
Is it possible to do a backup so it would be useful? Can we simply restore a table from a backup? Can it be used to display old data?
What if we want to do an ad-hoc test? Can a backup be used in Read-Write mode? Does this render backups unusable?
You will be shown how to make a backup that can be quickly used and thus increasing its value.
This presentation will be interesting for leaders, who always strive to reduce costs, DBAs that a are always short on time and programmers, because they like to develop using production data.