Error->Restore Master Database

Question

Post reply

Error->Restore Master Database

Analyst

Ten Centuries

Points: 1063
More actions
December 26, 2008 at 3:59 am

#126220

Hi All,
Am getting the below error while trying to restore the backed up master database (in single user mode only):
Master database Restore:The media set has 2 media families but only 1 are provided. ALL members must be provided.
Note: I cannot backup the master database again.
I would appreciate any kind of help for the above error.
Many thanks in advance!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 1

You performed a striped backup. The backup of master went to two files, not one and you are only specifying one file.

Unless you find the other file, you cannot restore.

Rajesh kasturi SSCarpal Tunnel Points: 4007 More actions · Answer 2

yes that is right you performed a striped backup, you can't restore until you find another file.

Rajesh Kasturi

Analyst Ten Centuries Points: 1063 More actions · Answer 3

But I think I had taken the backup in a single destination only.

Is it possible to get the error in the above case?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

jananik (12/27/2008)
But I think I had taken the backup in a single destination only.

Did you backup using the management studio gui? If there were two files listed in the destination box, the backup was striped across the two, even if one was highlighted.

Is it possible to get the error in the above case?

No. The error means that the backup was stripped and you only have some of the files.

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

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