Skip to end of metadata
Go to start of metadata

Symptoms

  • The error "The following databases are configured with Simple Recovery model and  will be skipped during Incremental (Log) backup." appears when one or more of the following actions is performed:
    • A backup set is saved
    • A backup set is validated
    • A backup is triggered manually or via schedule
  • A list of databases will be displayed as part of the error message.

What's going on?

Databases configured with the SIMPLE recovery model cannot be backed up with an Incremental (Log) backup.

Please see this Microsoft article for more information about database recovery models.

Resolution

There are several possible solutions:

  1. Reconfigure the database(s) to use the FULL recovery model via the SQL Management Console.
  2. Do not perform Incremental (Log) backups of SIMPLE database(s)