10

I'm trying to do a simple backup to an external disk and getting this error:

Backup failed for Server 'Server-name'

Additional information:

System.Data.SqlClient.SqlError: The media loaded on "C:\Program Files\Microsoft SQL.." is formatted to tsupport 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)`

Backup type: Full

Why am I getting this error and why is the message pointing to C:\Program Files.. if the destination file is an external device?

Aaron Bertrand
182k28 gold badges407 silver badges626 bronze badges
asked Aug 31, 2012 at 16:33
2
  • 2
    Please show your backup command. Commented Aug 31, 2012 at 16:34
  • 3
    Most likely you added a second destination file by accident? Commented Aug 31, 2012 at 16:37

2 Answers 2

11

This error means that you "striped" your backup across multiple files, and you're only providing one of the files when you're trying to restore.

If you're backing up using SQL Server Management Studio, make sure that you click "remove" to remove any existing backup destinations before you "add" the file you want to back up to.

answered Sep 9, 2012 at 18:54
-2

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.

answered Mar 25, 2017 at 5:41
1
  • You are correct, but this doesn't improve the existing answer. Commented Mar 25, 2017 at 11:24

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.