Very Computer

Hi,

Occasionally I get this error on restoring a backup set from other
server.
"the RAD set for database "MyDatabse" is missing memeber number 1.
Backup or restore operation terminating abnormally."

any tip.

Seems like you did a striped backup on the other server and you don't have
all the files/tapes when you do restore (The GUI can be a bit confusing).
Try below:

backup database pubs to disk = 'c:\pubs1.bak', DISK = 'c:\pubs2.bak'
restore database pubs from disk = 'c:\pubs1.bak'

--
Tibor Karaszi, Cornerstone Sweden AB
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Please reply to the newsgroup only, not by email.

Quote:> Hi,

> Occasionally I get this error on restoring a backup set from other
> server.
> "the RAD set for database "MyDatabse" is missing memeber number 1.
> Backup or restore operation terminating abnormally."

> any tip.