When Creating a SQL Server Database Backup, receive Error: "Backup failed for Server '<servername>\<instance name>'. (Microsoft.SqlServer.Express.Smo)" (Doc ID 2095560.1)

Last updated on JANUARY 26, 2016

Applies to:

Primavera P6 Professional Project Management - Version and later
Information in this document applies to any platform.


When attempting to create a new backup file for a SQL Server Express database, the following error occurs:

Backup failed for Server '<servername\Primavera>'. (Microsoft.SqlServer.Express.Smo)
Additional Information:
System.Data.SqlClient.SqlError: The media loaded on "<path\filename.bak>" is formatted to support 2 media families, but 3 media families are expected according to the backup device specification. (Microsoft.SqlServer.Express.Smo)

The issue can be reproduced at will with the following steps:

  1. Right click on Database, choose Tasks-> Backup Database.
  2. Back up to Disk, Add and Browse to location, create filename, and click OK.
  3. Observe error on execute.

The issue has the following business impact:
Due to this issue, users cannot backup the database to a new file .bak.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms