Hi,
I am facing one problem in restoring database. Please help me!.
1. I took a backup of database in sql server 2008 R2 from my own laptop. By mistake I forgot to remove old backup file. I want to restore backup on another computer
2. Now it is giving me error as follows
Restore failed for Server 'WIN2K8DSQL2K8R2\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
Now, I do not have my own laptop to take backup one more time. How can I restore backup without taking new backup??
Go to the complete details ...