Home > IT Answers > Storage > DataBase Restore
Claudiofuentes
15 pts.
 DataBase Restore
RAID, SQL Server 7.x, SQL Server database, SQL Server database restore, SQL Server errors
I'm working with SQL Server 7 and I made a backup from a DataBase and I need to restore it, but this error appear: "The RAID set for database is missing member number 1". What can I do???

Software/Hardware used:
ASKED: November 28, 2008  2:00 PM
UPDATED: December 2, 2008  8:02 PM
RELATED QUESTIONS
Answer Wiki:
This is a SQL Server error message and has nothing to do with the RAID arrays. This error is because you backed up the database using a strip set technique where you specified more than one backup file in the origional backup database command, and you are trying to use only one of the backup files. You need to specify all the members of the backup set when doing the restore. This <a href="http://support.microsoft.com/kb/256973">MSKB Article</a> should give you some info.
Last Wiki Answer Submitted:  November 29, 2008  11:24 pm  by  Paulus   130 pts.
All Answer Wiki Contributors:  Paulus   130 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

when I do a Restore labelonly from “xxx” the result is:

MediaName = null
FamilyCount = 2
FamilySequenceNumber = 2
MediaSequenceNumber = 1
MediaLabelPresent = 0
MediaDescription = null

but I continue with the error when I try to restore. What I have to do to specify all the members of the backup set when doing the restore?

Claudiofuentes
 15 pts.
 

You need to include the first member of the media family.

RESTORE DATABASE YourDatabase
FROM DISK='D:YourFirstBackupFile.bak',
           DISK='D:YourSecondBackupFile.bak'
Denny Cherry
 64,520 pts.