Join Martin Guidry for an in-depth discussion in this video Restoring logs, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] Now let's look at restoring logs.…In order to do a demonstration of restore,…I need some backup files to restore from.…I have several backups I've taken…in the previous demonstrations,…but I want to make sure I don't get confused…about what's been backed up and what hasn't been backed up.…So I'm going to take a fresh set of backups…for this demonstration.…I've created a new folder called Log Restore…and I'm going to put the backups there.…In Management Studio, I'll open a new query…and I'll write the command to take a full backup…of the database.…
It's just Backup Database,…the name of the database, To Disk…and the name of the file you would…like to backup to.…I'm calling mine AdventureFull…so I know it's the full backup of Adventure Works.…After that command, I'll put the keyword Go…to make sure that command is executed…before the next command is started.…And the next command will be the necessary…steps to back up the log.…So, this time instead of saying backup database,…we say Backup Log, again for Adventure Works.…
- 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.