INF: Error Message: 3132 "The RAID set for database ... missing member number" (256973)

SUMMARY

When you try to restore a database from a file, you may see this error message:

The RAID set for database '%ls' is missing member number %d.

This error occurs if a member of the stripe set (the backup was performed to more than 1 backup file/device) that was originally used to create the backup, was not selected when you tried to perform the restore. The number that displays in the message shows the set or file number that is missing.

MORE INFORMATION

To reproduce the issue, use the pubs database and 2 devices, pubs_1.dat and pubs_2.dat:

From server1, create the backup device for the full pubs backup.

USE master
EXEC sp_addumpdevice 'disk', 'pubs_1', 	'c:\mssql7\backup\pubs_1.dat'
EXEC sp_addumpdevice 'disk', 'pubs_2', 	'c:\mssql7\backup\pubs_2.dat'
-- Backup pubs database.
BACKUP DATABASE pubs TO pubs_1, pubs_2

Now, use Query Analyzer and use RESTORE from only 1 device with this command:
```
RESTORE DATABASE pubs2 FROM pubs_2
					
```
This error message appears:
Server: Msg 3132, Level 16, State 1, Line 1
The RAID set for database 'pubs2' is missing member number 1.

Note that to see the members involved in the backup set you can also use this command:

RESTORE LABELONLY FROM pubs_2

Check the FamilyCount (the number of backup devices this backup uses) and FamilySequenceNumber (indicates the sequence of this backup device).

You can also view the same information by using these steps:

Perform a restore from SQL Server Enterprise Manager.
Highlight the backup job in question.
Click the Properties dialog box.