Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Network Performance Monitor (NPM) > Error: Failed to restore Orion DB backup The media set has 2 media families but only 1 are provided

Error: Failed to restore Orion DB backup The media set has 2 media families but only 1 are provided

Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 29 Votes: 0 Revisions: 4

Overview

This article describes the issue when you receive the following error error while restoring Orion DB backup  to new SQL Server:

Failed to restore Orion DB backup The media set has 2 media families but only 1 are provided

 

 

Environment

All versions of NPM 

Cause 

This error message occurs because the original backup was done as a striped backup where the backup stream was split into two destination files.

When attempting to restore, you need to specify all of the same files which were used to take the backup.

 

This works similar to RAID1, which means, we do not have one set of data on one file and another set of data on the other one. How it works is the data is inerspersed between the two files, which is the behavior that gives optimum performace.  One of the unfortunate results of this is you cannot get any data out of a subset of the backup files used to create the backup.

 

The reason that you cannot do a backup adding on to one of these files is that the files themselves are initialized to understand that they are part X of a Y-part backup. If you specify only one file, it doesn't fit.

You can always perform a backup by specifying a new backup file, and using WITH INIT.

 

If you don't need to stripe the backups across multiple files for performance reasons, go with a single destination for management simplicity.

 

The simple version is:

If you back up to two files, you must specify two files to restore from. If you back up to five files, you must specify five files to restore from, etc.

 

You cannot restore any data from less than the full set of files used for the backup.  This isn't like RAID 5 where we can synthesize missing data, nor is it a continuation volume, where we could restore up to the missing bit.

 

Resolution

We recommend to consult your DBA for any further action to restore all the DB files as explained under this post:

https://social.msdn.microsoft.com/Fo...forum=sqltools

 

Last modified
22:15, 22 Jun 2016

Tags

Classifications

Public