DataBase Restore
Home > IT Answers > Storage > DataBase Restore
Claudiofuentes
15 pts.
0
Q:
DataBase Restore
RAID, SQL Server 7.x, SQL Server errors, SQL Server database restore, SQL Server database
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???
ASKED: Nov 28 2008  2:00 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 MSKB Article should give you some info.
Last Answered: Nov 29 2008  11:24 PM GMT by Mrdenny   46795 pts.
Latest Contributors: Paulus   130 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Claudiofuentes   15 pts.  |   Dec 1 2008  6:35PM GMT

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?

 

Mrdenny   46795 pts.  |   Dec 2 2008  8:02PM GMT

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

RESTORE DATABASE YourDatabase
FROM DISK=’D:YourFirstBackupFile.bak’,
           DISK=’D:YourSecondBackupFile.bak’

 
0