November 14, 2013 at 8:50 am
I backed up a SQL Express 2012 DB I was working on prior to the OS crashed. The hard disk has since been formatted twice and new OS installed. Now, when I tried to restore my DB I get an error "Media Set 1, Family Count 2. Need all Media Sets to for restore. RESTORE operation terminated".
My search in the net suggested that this would have happened because I specified two different back up locations. As far as I recollect, that was not the case and I have only one backup file.
The contents of the backup is attached.
Is there any method by which I can restore this DB?
November 16, 2013 at 7:23 am
Any suggestions from anyone, please?
November 16, 2013 at 8:13 am
The error is because two files were specificed for the backup. This is commonly by mistake, where there were two files listed in the destination box on the backup dialog when that backup was made. The backup doesn't go to the latest added or to the highlighted one, it's stripped across both and you need both files to restore. There's no way to restore with only half a backup as you only have half of the database there.
If you have a backup of MSDB from before the reinstall, restore that and look at the backup history, it'll tell you want files the backup was striped across. Not sure if the info on which files the backup was striped across is part of the backup header.
RESTORE LABELONLY might give you more info, but I don't think it'll tell you where the other file is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply