Join Martin Guidry for an in-depth discussion in this video Performing a tail backup, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] In this section, we're going to talk about…a special type of transaction log backup…called a tail log backup.…Tail backups are not required in all situations.…This is commonly done when we intend to…shut off a database.…So, for example, if you are planning to…shut off a database at one location,…and then restore it on a different server,…the last thing you would want to do…before you shut off the database…is perform a tail log backup.…The term tail implies it is the end of the backup sequence.…
So here in AdventureWorks,…I'll right click, go to Tasks,…and then go to Back Up.…In the Backup type, I'll select Transaction log,…and on the Media Options page,…towards the bottom I have radio buttons for either…the default of "Truncate the transaction log" or…"Backup the tail of the log…and leave the database in the restoring state".…So this is going to back up the end of the log…and basically turn off our database.…
It's called in a restoring state,…meaning it will not accept new connections…and it will not accept new transactions.…
- 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.