Join Martin Guidry for an in-depth discussion in this video Copy-only backups, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] Now let's talk about copy-only backups.…In SQL Server, a copy-only backup…is a special type of full backup.…It's different than other full backups…in that it does not become the base…of the next differential backup, so a differential backup…is always based on a full backup and what it backs up…is the changes since that last full backup,…but if we do a copy-only backup,…it does not become the base of the next differential backup.…
The next differential backup will still…be based on the previous full backup.…It's somewhat unusual that you would want to do this,…but if you're taking backups on a regular schedule…and writing them all to the same media…and then for some reason you need to take a full backup…that's not part of that schedule…or will not go onto the same media,…you might wanna use a copy-only backup.…If not, you could find yourself, when doing a restore,…of being unsure of which full backup…is connected to which differential backup.…
Performing the copy-only backup is very simple.…We'll do a few quick demos here.…
- 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.