System.Data.SqlClient.SqlError: The media loaded on X is formatted to support 1 media families, but 2 media families are expected according to the backup device specification

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.

System.Data.SqlClient.SqlError: The media loaded on X is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)

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. 🙂

Leave a Reply