Hello!
The comments on this profile are unclaimed and thus are unverified.
Do they belong to you? Claim these comments.
umesh
Is this you? Claim Profile »
7 months ago
in SQL Server 2005: How To Restore a Database from a Backup | Database | Tech-Recipes on Tech-Recipes
I taken backup of database from Sql server 2005 from other PC and try to Restore it on my PC. Both having Windows authentication. But i am facing following error
System.Data.Sqlclient.sqlError:The media set has 2 media families but only 1 are provided.All member must be provided.(Microsoft.Sqlserver.Smo).
IS it problem of Ownar . because owanr of .bak file is different from where i try to restore it.
System.Data.Sqlclient.sqlError:The media set has 2 media families but only 1 are provided.All member must be provided.(Microsoft.Sqlserver.Smo).
IS it problem of Ownar . because owanr of .bak file is different from where i try to restore it.
1 reply
This is not the problem of owner, it is just because while selecting the restoring device there must be two paths (1. Default by Microsoft, 2. Given by you).
So delete the default path given by SQL Server itself, so it remains only one path that is given by you.
Do let me know in case this doesn't work also
Regards,
Himanshu