Backup Problem - multiple family members

I have a backup that has been working successfully for the past two months, but this weekend the following error message appeared.

"The media set for database 'MyDB' has 2 family members, but only 1 are provided. All members must be provided."

I checked the contents from the previous backups, and they all have 1 family member, and 1 media set?

Any ideas on what has changed, and what I need to do to fix this?i have encountered this. just delete your backup device from the harddisk totally then make a new backup device.

hope it should work for you.|||Thanks, that worked. Though I still wonder what caused the problem.

Originally posted by kenz
i have encountered this. just delete your backup device from the harddisk totally then make a new backup device.

hope it should work for you.

Backup History Purge

I work in a small shop and I noticed this weekend that when SQL performs a
backup it must keep this information somewhere as I found that I have over 3
years of backup history when I restore a database. Can someone explain to
me how to purge this history information?
Thanks,
MattCheck out sp_delete_backuphistory in BooksOnLine. Just be fore warned that
this sp can take a LONG time when there are lots of reow in the table.
Andrew J. Kelly SQL MVP
"Matt Frame" <mdframe@.DONT-SEND-ME-EMAIL.sorvive.com.NO-SPAM> wrote in
message news:u$1qvQBEEHA.3748@.TK2MSFTNGP11.phx.gbl...
> I work in a small shop and I noticed this weekend that when SQL performs a
> backup it must keep this information somewhere as I found that I have over
3
> years of backup history when I restore a database. Can someone explain to
> me how to purge this history information?
> Thanks,
> Matt
>|||-- deletes all backup history for all databases before the date specified
EXEC sp_delete_backuphistory '2002-09-01'
-- deletes all backup history for the db specified
EXEC sp_delete_database_backuphistory 'db_one'
very useful commands. if you do restores from enterprise manager, getting r
id
of the old backuphistory can speed up the time it takes for the initial rest
ore
screen to load.
Matt Frame wrote:

> I work in a small shop and I noticed this weekend that when SQL performs a
> backup it must keep this information somewhere as I found that I have over
3
> years of backup history when I restore a database. Can someone explain to
> me how to purge this history information?
> Thanks,
> Matt