Backup failed for Server, The media is formatted to support 2 media families Error

The backup statement is using the NOINIT clause. This causes each successive backup to append to the existing backup file. You are attempting to backup to one media set (one file), but it appears the existing backup you are attempting to append to consisted of two media sets (two files).

For a quick turnaround, specify a new filename: BACKUP DATABASE [Payroll] TO DISK = N'D:\Project 2014\<insert new filename>' WITH ...


A simple solution has arisen (via SSMS), based on the answer of @DMason and answer of @Carol Baker West.

enter image description here

Just create a new media set for a single media family.

https://i.stack.imgur.com/C6eNN.gif


I also received the error. In my case, I wanted to specify a different location to which the file should be backed up to. But what it was trying to do, was to now split the backup to both files in both locations - thus the part of the error:

is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)

So, remove one of the destinations specified in the 'Destination' section of the Back Up Database wizard. It should only have one destination if it only backed up to one file previously.