Hello to all......
Me and my friend are currently working on project using Visual studio 2010 as frount end and SQL Database as back end.
As we both are working on same topic so we made database in both laptop say A and B.
Now when i first make a backup of database from my laptop (say A) and want to restore the same in my friend's laptop (say B),i got the Error message.
The same case occur with the database made in laptop B,and wouldn't restoring in System A.
Can anyone have a solution of this problem.
Currently we both have same Server type i.e. Database Engine.
same Authentication i.e. SQL Server Authentication
same Login ID i.e sa.
but DIFFERENT Server Name and Password.
The Error Message is
Restore failed for Server 'RAJESHKUMARGUPT'. (Microsoft.SqlServer.Smo)
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided.All
members must be provided. (Microsoft.SqlServer.Smo)