I want to backup Database and restore it again, but after backup and try to restore it error message appear:
SqlError The media set has 2 media families but only 1 are provided
I can not to restore my database again.
I use SQL Server 2005
Edited 9-Oct-12 22:15pm
when u created backup it may be possible that in the list displayed in bottom you had two different backup files added and now you are restoring with only one file. please check. re create backup after deleting all existing backups. hope it solves your problem. happy to help.........
chose mdf file location
and log file location
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)