SQL Server - system.data.sqlclient.sqlerror the media set has 2 media families but only 1 are provided
Asked By reenu Ch on 22-Jun-12 01:42 AM
Hi
When Restore Database into Sql Server 2008
I got this Error,
Restore Failed for server
system.data.sqlclient.sqlerror the media set has 2 media families but only 1 are provided.All Members must ve Provided.
Thanks
Sreenu. Ch
Vikram Singh Saini replied to reenu Ch on 22-Jun-12 10:29 PM
The cause of problem is:
When backup was done it was not a complete single file backup but it was striped backup i.e. backup was done in two files for performance issue. So when the backup is done, the first file (x) contains information that there is second file (y) which contains continuing backup of this file. And the second file(y) contains information that there is first file(x) which contains backup.
So whenever you try to restore the files to database it expects the second file to be there in same folder. Do check the backup file(s) in directory, which you are trying to restore. There would be a second file too.
Credit: The above idea has been picked from link http://social.msdn.microsoft.com/Forums/en/sqltools/thread/abf50e00-c9b0-4809-9e61-43ed8a53e968. And the link also contains six accepted solutions for very same problem. I hope that would help you in all.
Licensing SQL Server SQL Server
Hi Guys I ordered MS Sql Server 2005 (x32) Single Processor (MPN 228-04026) the other day. Today I received MS Sql Server 2005 (x64) Single Processor (MPN 228-04019) plus Microsoft SQL server 2005 (x32) Media Kit
Can't find SQL Server Management Studio after install SQL Server 2 SQL Server
I've installed SQL Server 2005 Developer edition and SQL SP2 on a PC running Windows Vista Business SP1. The
Browse for SQL Server 2008 Installation Media SQL Server
Hi: I am trying to install SQL Server 2008. In SQL Server Installation Center, when I click on "New SQL Server stand-alone installation or add
SQL Server client components - What is this? SQL Server
Hi, I need to install SQL Server client components (as Symantec calls it) so as to access my SQL Server 2005. Where do I find the SQL Server client components installation code? Is this on
Dear Sir, When i am uninstalling sql server 2005 express through add remove program in control panel, my system reboots without uninstalling sql server. This occurs every time i uninstall sql server. Pls help me how to uninstall sql
[Sql Server 2008 RCO]Where is SSMS ? SQL Server
Sql Server 2008 RCO]Where is SSMS ? SQL Server Hi there, a very simple question: I cannot find the SSMS component during the Server 2008 RC0 installation process. Is it on a separate download ? Thanks a lot SQL Server Tools Discussions SQL Express 2008 (1) SQL Server 2005 (1) SQL Server 2000 (1) SQL Server 2008 (1
SQL Server 2005 Installation on server running SQL Server 200 SQL Server
I am trying to install SQL Server 2005 on a server (non domain ctrl) running SQL Server 2000. It will not
oblem using - Upgrade from SQL Server 2000 or SQL Server 2005 wiza SQL Server
Hi, I have a Itanium 2 server that is running the folowing instances: MSSQLSERVER - SQL Server 2000 IA-64 Enterprise Edition. MSSQL$AS2000 - SQL Server 2000 and Analysis Services 2000
SQL Server Manager 2005 vs Server Manager EXPRESS SQL Server
HI I have inherited a server that has SQL Server 2005 installed on MS Server2003 OS - Problem - MS SQL server manager studio EXPRESS is installed
Cannot Install SQL Server SP2 SQL Server
I'm trying to install SQL Server SP2 on a SQL Server 2005 Developer Edition. I'm running SQL Server 2005, SSAS 2005, SSIS 2005, & SSRS 2005