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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2010-11-28 : 06:19:25
|
| i'm trying to backup a database to restore to a different server but i'm getting the errror when restoringSystem.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)what am I doing wrong when doing the backup and what is the correct way to backup so that I can restore on another computer. |
|
|
MohanKandasamy
Starting Member
9 Posts |
Posted - 2010-11-28 : 07:46:03
|
| Hi,Are you restoring the database backup from sql 2008 to sql 2005 server ?Mohan Kandasamy |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2010-11-28 : 07:52:17
|
| no both 2005 |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-28 : 08:00:25
|
| When you took the backup, you specified two files (either two files in the BACKUP DATABASE statement or two files in Management Studio's destination dialog). That means that the backup was striped across them (part written to the one file, part to the other). You need both files and you need to specify both files when you do a restore.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
backup and restore