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.
| Author |
Topic |
|
vgr.raju
Yak Posting Veteran
95 Posts |
 Posted - 2006-06-16 : 13:02:26
|
| Hello Experts, I am getting the following error while I try to restore the DB in sql server 2005.System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)Any Help would be Greatly Appreciated!Thanks!Raju |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-06-16 : 16:31:27
|
| Raju,How you are restoring the database? From any tool or application?Is this database created on sql 2000 Or sql 2005?With RegardsBSR |
 |
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-06-16 : 16:42:27
|
| I am connected to the SQL Server 2005 Database.Just using the Restore with the Move option.Thanks!Raju |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-16 : 17:08:38
|
| You need to specify which file you want to restore as your backup has two files inside it. You can do this with the restore command via the FILE = option.RESTORE DATABASE ...FROM ....WITH ... FILE = 1(maybe 2)Tara Kizeraka tduggan |
|
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-06-19 : 18:21:50
|
| Thanks for your help.Actually the backup file was corrupted.Again I took the Backup and successfully restored on the server. |
|
|
|
|
|
|
Error in Restores