---
title: "Showing error while back up the database in sql server"  
description: "Showing error while back up the database in sql server"  
author: "Anonymous User"  
published: 2015-06-15  
updated: 2015-06-15  
canonical: https://www.mindstick.com/forum/23295/showing-error-while-back-up-the-database-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Showing error while back up the database in sql server

I am facing some error while i [am trying](https://answers.mindstick.com/qa/36834/which-two-programming-languages-should-i-master-in-if-i-am-trying-to-get-into-google-or-facebook) to back up my [database in sql](https://www.mindstick.com/forum/158348/how-do-you-create-a-new-database-in-sql-server) [server R2](https://www.mindstick.com/forum/33471/files-struck-in-restoring-status-sql-server-r2-2008). it is showing the following error:\
TITLE: [Microsoft SQL](https://www.mindstick.com/forum/159597/my-sql-server-vs-microsoft-sql-server-which-one-better) Server [Management Studio](https://www.mindstick.com/forum/159668/what-is-the-difference-between-sql-server-and-sql-management-studio)\
Restore [failed for Server](https://www.mindstick.com/forum/23293/sql-server-restore-failed-for-server-servebrname) 'Ironhide\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)\
[ADDITIONAL INFORMATION](https://www.mindstick.com/forum/160484/error-failed-to-launch-debug-adapter-additional-information-may-be-available-in-the-output-window):\
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All [members must be provided](https://www.mindstick.com/forum/23294/ms-sqlserver-error-the-media-set-has-2-media-families-but-only-1-are-provided-all-members-must-be-provided). (Microsoft.SqlServer.Smo)

## Replies

### Reply by Anonymous User

Anyway, your backup set was splitted in two files, but you're trying to restore the data from just only one backup file.

One solution is to backup your data in just one file and repeat the restore process. The other one is to provide both backup files and try to restore again the data. In this way, [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) won't warn you again with that error.

Refer this thread

**Sql server - Restore failed for Server 'servebrname'.**


---

Original Source: https://www.mindstick.com/forum/23295/showing-error-while-back-up-the-database-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.