160 likes | 318 Views
BACKUPS. What is your plan???. Plan in Writing. “A goal without a plan is just a wish.” Antoine de Saint- Exupéry. The 5 W’s. Who What When Where Why. Why?. The average lifespan of a hard drive is 3 years. Plan B, C, D…. Cover as many “What if’s” as you can. .
E N D
BACKUPS What is your plan???
Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry
The 5 W’s Who What When Where Why
Why? The average lifespan of a hard drive is 3 years
Plan B, C, D… Cover as many “What if’s” as you can.
Backup Plan For Your Backup A – Daily backup procedure B – Backup operator is out C – What if it fails? D – Disaster recovery
SQL Structured Query Language
How Does This Change Things You can not run a live backup The data must be exported
Backup Destinations Tapes USB Flash drives Portable Hard Drives SSD vs Spinning Hard Drive Cloud
Backup Destinations Tapes USB Flash drives Portable Hard Drives Cloud Holds a lot of data Easy to use, inexpensive Easy to use, lots of space Happens continuously
Backup Destinations Tapes USB Flash drives Portable Hard Drives Cloud Fragile, slow Can be Slow, Drive letter can change Can be damaged with a drop Depends on internet connection
Checking Your Backup Know how to check your backup log Record when and who checks it Look for trends in your backup
Restoring Data How do you verify a backup? Can you do a selective restore? How long does a restore take?
Security How much security do you need? Physical Controlling Access Encryption AES, Serpent, Twofish, RSA, Elliptic Curve, Tiple DES
What Is Next Everything in the cloud? SQL is here to stay It will always be evolving