Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

PDF

Circumstances that promote Microsoft SQL Server backups to level full

Transaction log backups and differential backups are promoted to full backups in certain situations.

By default, transaction log backups and differential backups are promoted to level full in the following scenarios:

  • When there is not an existing level full backup.
  • When a log gap is detected.
  • When the recovery model is changed.
  • When the backup includes simple model databases, either the simple model databases are promoted to a full backup or the simple model databases are skipped, depending on the backup settings.
  • When the database has been newly restored.

Options to tune the behavior of automatic promotion are available while configuring a backup. The ddbmsqlsv -a "BACKUP_PROMOTION" command flag and the Microsoft app agent for Application Direct SSMS plugin Backup Promotion option both control backup promotion.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\