Microsoft KB Archive/256973

= INF: Error Message: 3132 "The RAID set for database ... missing member number" =

Article ID: 256973

Article Last Modified on 10/27/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q256973



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:
 * 1) Perform a restore from SQL Server Enterprise Manager.
 * 2) Highlight the backup job in question.
 * 3) Click the Properties dialog box.

Keywords: kbinfo KB256973

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.