Join Martin Guidry for an in-depth discussion in this video Understanding recovery point objective and recovery time objective, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] So now let's talk about some…objectives or goals you should think about…when planning your backup strategy.…The first one is the recovery point objective,…or RPO, and this is the point in time that…data can be restored to, so if your most…recent backup is a month ago, you are…only going to be able to restore to…what the database looked like at…that time the backup was taken,…so you will potentially lose a month of data.…On the other hand, if your most recent…backup was taken five minutes ago,…then you can restore up to that point in time…and you would only lose five minutes of data.…
So you need to ask yourself how much…data are you willing to lose, are you…willing to lose hours of data, minutes of data,…seconds of data, or zero data?…If you are unwilling to lose any data,…if you absolutely positively have to have…zero data loss, then backups alone are…not going to solve your problem.…You would need to look into high…availability solutions, like clustering,…or availability groups.…These solutions can get very expensive…
- Types of backups
- Media sets and backups
- Performing a basic backup using the GUI or command line
- Performing a basic restore using the GUI or command line
- Backing up and restoring logs
- Doing partial backup and restores
- Automating backups
- Using encryption and compression
Skill Level Intermediate
SQL Server 2014: Installation and Administrationwith Ron Davis3h 40m Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
Migrating Access Databases to SQL Serverwith Adam Wilbert2h 38m Intermediate
1. Backups in General
4. Partial Backups and Restores
5. Other Backup Topics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.