Join Martin Guidry for an in-depth discussion in this video Understanding recovery models, part of SQL Server 2014 Backup and Recovery.
- [Voiceover] In this section,…we're going to talk about the different…recovery models available in SQL server.…Microsoft SQL server offers three…different database recovery models.…They are simple, full, and bulk logged.…We'll talk about each one of these individually.…In the simple recovery model, the server…only performs minimal logging,…so only a very small amount of information…is written to the logs during a transaction…and as soon as that transaction completes,…the information is cleared out of the log.…
Therefore, there is no reason to…back up the transaction log, and actually,…you cannot perform a transaction log backup…on a database in the simple recovery model.…All of this simplifies both the backup and restore process.…It does limit our options though.…For a database in the simple recovery model,…when we do a restore, we can only restore…to the point of time of the most recent backup.…That's our only option.…Contrast that to the full recovery model…in which detailed logging occurs about every transaction…
- 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
Installing and Administering Microsoft SQL Server 2014with Ron Davis3h 41m Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
Migrating Access Databases to SQL Serverwith Adam Wilbert2h 39m 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.