Home > Archive > MS SQL Server > April 2006 > The media set has 2 media families









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author The media set has 2 media families
thejamie

2006-04-08, 7:23 am

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

This is an error received when I try to restore a database from backup.
Anyone know what it means?
--
Regards,
Jamie
Tibor Karaszi

2006-04-08, 7:23 am

The backup was striped over two files and you try to restore from only one of the files. You can
verify this using RESTORE LABELONLY.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

Blog: http:// solidqualitylearning
.com/blogs/tibor/



"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:10F943D8-D754-465C-A7F4- 08B482A0A8FF@microso
ft.com...
> System.Data.SqlClient.SqlError: The media set has 2 media families but only 1
> are provided. All members must be provided.
>
> This is an error received when I try to restore a database from backup.
> Anyone know what it means?
> --
> Regards,
> Jamie


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com