Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 media set has 2 media families but only 1 provided

Author  Topic 

thendraljazz
Starting Member

26 Posts

Posted - 2012-02-13 : 04:58:19
Hi

While restoring database i got the following error..

Error:the media set has 2 media families but only 1 are provided all members must be provided

Can any one tell me the solution?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-13 : 08:13:01
Solution is to take another backup or find the second file.

What that's saying is that when the backup was taken it was striped over two files, so each file has half of the backup. This is sometimes done by accident when backing up with the SSMS gui. If there are two files listed in the destination text box, the backup will be striped across the two and you'll need both for the restore.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -