backups what is your plan???. plan in writing “a goal without a plan is just a wish.” antoine de...
TRANSCRIPT
![Page 1: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/1.jpg)
BACKUPS
What is your plan???
![Page 2: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/2.jpg)
Plan in Writing
“A goal without a plan is just a wish.”
Antoine de Saint-Exupéry
![Page 3: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/3.jpg)
The 5 W’s
WhoWhat
WhenWhere
Why
![Page 4: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/4.jpg)
Why?
The average lifespan of a hard drive is 3 years
![Page 5: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/5.jpg)
Plan B, C, D…
Cover as many “What if’s” as you can.
![Page 6: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/6.jpg)
Backup Plan For Your Backup
A – Daily backup procedureB – Backup operator is outC – What if it fails?D – Disaster recovery
![Page 7: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/7.jpg)
The Changing Face of Backup
![Page 8: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/8.jpg)
SQL
Structured Query Language
![Page 9: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/9.jpg)
How Does This Change Things
You can not run a live backupThe data must be exported
![Page 10: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/10.jpg)
Backup Destinations
TapesUSB Flash drivesPortable Hard DrivesSSD vs Spinning Hard DriveCloud
![Page 11: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/11.jpg)
Backup Destinations
TapesUSB Flash drivesPortable Hard Drives
Cloud
Holds a lot of dataEasy to use, inexpensiveEasy to use, lots of spaceHappens continuously
![Page 12: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/12.jpg)
Backup Destinations
TapesUSB Flash drives
Portable Hard Drives
Cloud
Fragile, slowCan be Slow, Drive letter can changeCan be damaged with a dropDepends on internet connection
![Page 13: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/13.jpg)
Checking Your Backup
Know how to check your backup logRecord when and who checks itLook for trends in your backup
![Page 14: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/14.jpg)
Restoring Data
How do you verify a backup?
Can you do a selective restore?
How long does a restore take?
![Page 15: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/15.jpg)
Security
How much security do you need?Physical
Controlling AccessEncryption
AES, Serpent, Twofish, RSA, Elliptic Curve, Tiple DES
![Page 16: BACKUPS What is your plan???. Plan in Writing “A goal without a plan is just a wish.” Antoine de Saint-Exupéry](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e915503460f94b96047/html5/thumbnails/16.jpg)
What Is Next
Everything in the cloud?SQL is here to stayIt will always be evolving