My one of the client wanted to full backup of his SQL Server database but getting failed with below mentioned error:
Error:
System.Data.SqlClient.SqlError: The media loaded on "H:\*******20141014.bak" is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)
Screen shot: You can see two backup media locations has been mentioned for full database backup.
Root Cause:
When we add more than one backup location, than we are asking SQL Server to take backup on more than one backup location, means backup would be stripped/divide over the backup locations. You need both the stripped backup piece at the time of restore.
Solution:
To avoid above error, just replace your new backup location with listed backup locations. Means remove all old entry and add your new backup location. It will work.
Stay Tune. 🙂