Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RESTORE, Media Set and Family Count Expand / Collapse
Author
Message
Posted Thursday, November 14, 2013 8:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 22, 2014 9:52 PM
Points: 20, Visits: 36
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?


  Post Attachments 
Screen Shot.png (7 views, 58.71 KB)
Post #1514327
Posted Saturday, November 16, 2013 7:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 22, 2014 9:52 PM
Points: 20, Visits: 36
Any suggestions from anyone, please?
Post #1514919
Posted Saturday, November 16, 2013 8:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 42,485, Visits: 35,554
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1514922
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse