Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 15th, 2010, 05:48 AM
Registered User
 
Join Date: Feb 2010
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Default database restore problem

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1
are provided. All members must be provided.

i have encountered with this problem,.,.plz help me out of this problem
 
Old June 15th, 2010, 10:43 AM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

This sounds like the database you are trying to restore is made up of multiple files. For SQL this is usual: the MDF (data) file, and the LDF (log) file. Typically when you restore a database you need to refer to all the files that make it up.
__________________
-Peter
compiledthoughts.com
twitter/peterlanoie





Similar Threads
Thread Thread Starter Forum Replies Last Post
I can't Restore Database from this book carrascojg BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 4 September 20th, 2008 06:10 AM
I can't Restore Database carrascojg BOOK: Expert SQL Server 2005 Integration Services ISBN: 978-0-470-13411-5 0 August 25th, 2008 01:34 PM
Problem to restore database in C#2005 database acmuralee MySQL 0 March 25th, 2008 04:42 AM
How to restore a deleted database ? tiahvera SQL Server 2000 1 July 23rd, 2007 08:22 AM
restore database angelboy C# 2005 0 April 17th, 2007 08:40 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.