Copy-Only Backups Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Backup and Restore

What you'll be asked

  1. What is the primary purpose of a 'Copy-Only' backup in SQL Server?
  2. If you perform a 'Copy-Only' full backup, how does it affect the next scheduled differential backup?
  3. Which scenario is the most appropriate use case for a 'Copy-Only' backup?
  4. When performing a 'Copy-Only' transaction log backup, what happens to the transaction log file?
  5. If a database is in Full Recovery mode and you perform a series of standard log backups followed by a 'Copy-Only' log backup, what is the impact on the restore sequence?

Answers and explanations come after you submit.