SQL Server backup failed - 2 media families expected

Our automated backup is failing. When I try to create a backup manually I get the error message below which refers to media families. The SQL server is 2008 standard (version 10.0.2714.0 according to the properites window). It is running in a virtual environment. Automated backup was crteated using the maintenance plan wizard. By manually I mean from the Tasks | Backup option in Management Studio.

This is the message:
 
Sysentem.Data.SqlClient.SqlError: The media loaded on "F:\Backup\Links of London\Links of London_backup_2012_03_23_060000_8777321.trn" is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)
Blim2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Blim2Author Commented:
I'd like to update my [problem. I am now getting this error message:

System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file "F:\Backup\Links of London\Links of London_backup_2012_03_23_080000_7357745.trn:" 112(failed to retrieve text for this error. Reason: 15105). (Microsoft.SqlServer.Smo)

I think the previous error may have been due to having two backup file names in the Backup To window. Sorry for the confusion.
0
Blim2Author Commented:
I may have solved this myself. I think the problem was that I did not delete an existing file name from the Backup To window. When I added another of my own I got the 1/2 media families supported error. When I left the filename that was already there, presumably created by the maintenance plan automated backup, I got the I/O error. When I deleted the file name that was already there and added a single, new, name, the backup started and is now still running.

I'm guessing the filename that was already there was for an existing backup file and the I/O error meant that the system could not overwrite this file. Possibly a more meaningful error message would have helped here!

How do I end this Experts-Exchange question. I don't think I should give the points to myself - doesn't seem fair?
0
EE_AutoDeleterCommented:
Because this question has no expert participation and is over 21 days old, it would have been deleted automatically, but you have posted information yourself making this PAQ-worthy.

EE_AutoDeleter
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.