Menu
SQL server error The media set has 2 media families but only 1 are provided. I am trying to restore a 200 MB database into SQL 2008 and I am getting this error
"The media set has 2 media families but only 1 are provided. All members must be provided
977
Media sets can be mirrored to protect against a damaged media volume (a tape or disk file). For more information, see Mirrored Backup Media Sets (SQL Server). Compressed and uncompressed backups can't occur together in a media set. Any edition of SQL Server 2008 or later can read compressed backups.
You are getting this error because your database backup was striped and the backup stream was split into two destination files. You are trying to restore from a single backup file. You need both files to restore your database.
For more information on the error, refer here
92
its kinda late but here's how I managed to fix this issue.
It seems that you have left another location while doing the back-up. Delete the other location and keep your specified one.
Putting two locations would stripe the file into two parts, meaning you need two files to complete the restoration.
Hope this helps. Cheers!
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
