Tradeoffs of Backups and Restore Strategy Design

This video starts with a conversation around a customer’s requirement to reduce their storage costs by archiving but then they lose access to useful information. We discuss the trade-offs for a backup and restore strategy (1) Speed, (2) Storage Costs/Savings (3) Resource Utilization (4) DB Size. The conversation touches on the need for a DBA to have control over the restorability of a backup and the granularity of that restore – no one wants to restore an entire database, just to undo a 1,000-row delete error. Learn More