Join Martin Guidry for an in-depth discussion in this video Backing up logs, part of Microsoft SQL Server 2014: Backup and Recovery.
- Now let's do quick demo…on how to perform…a transaction log backup.…Here in Management Studio,…I'll right click on the database.…Go to Task and Back Up.…In the backup dialogue,…one of the options is Backup type.…It defaults to Full.…But in that dropdown,…we have the option for Transaction Log.…You will not see this option…if you are in the simple recovery model…because in the simple recovery model,…you cannot back up the transaction log.…
But because I'm in the full recovery model,…I do get the option for Transaction Log.…Pretty much all of the other options are the same now.…It does ask me for a destination.…I could keep the same file name,…but I would like to change that.…So I'll click Add.…And where it says Destination on disk,…I'll click the three dot button.…I want to keep it in the same folder,…but I'm going to give it a different name.…Traditionally, full backups and differential backups…have the extension bak,…but transaction log backups have the extension trn.…
It's not required.…Your backup will still work regardless…
- 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.