Join Martin Guidry for an in-depth discussion in this video Best practices, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] Now I'd like to give you a few tips…for backing up Microsoft SQL Server.…You certainly need to take some time…to consider the frequency of your backups.…Typically the more frequently you backup,…the better shape you'll be in if a disaster occurs…and you need to restore.…Now be aware that every backup…does take some amount of resources,…so therefore there's going to be some budgetary constraints…on just how practical it is to backup more frequently.…You also need to consider how often your data changes.…Obviously data that changes very frequently…needs to be backed up very frequently,…but data that changes very seldom…doesn't need to be backed up as often.…
You'll also need to consider your storage location.…If you store all of your backups on site…and some physical disaster occurs at your building,…it could destroy not only your servers…but also destroy all of your backup media…meaning you would have no way to restore.…Whereas if you were storing some of your backups off site,…then the physical disaster that destroyed your server…
- 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 Essential Trainingwith Martin Guidry3h 51m Intermediate
SQL Server 2014: Installation and Administrationwith Ron Davis3h 40m 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.