I am running into this error when trying to Backup a database:
"The media set has 2 media families but only 1 are provided. All members must be provided."
Please note this is on BACKUP not on restore.
There are a lot of topics on this error for RESTORE, but I didn't find any for BACKUP.
I am using this T.SQL on Sql Server 2005:
backup database dtplog
TO DISK='e:\dtplog.bak'
So it looks like SQL Server has some kind of setting specified there are multiple backup devices for this database.
For some databases I don't get this error, but for some I do.
Any idea what's happening?