Error 3123 in SQL Restore

Trying to restore a database from a personal edition SQL 2000 to another PC.
I get the following message
The media set for database 'TeamSpiritDataTDB' has 2 family members but only
1 are provided. All members must be provided.
What does this actually mean. Is the file corrupt, or is there a problem
with the way it was backed up? I didn't back it up, but our normal procedure
in this circumstance is just to make a complete back up to a file.
Any ideas gratefully received.
Thanks
RowlandThe backup was take to multiple disks and you have provided only one.
http://forums.databasejournal.com/history/topic.php/33896-1.html
--
Nik Marshall-Blank MCSD/MCDBA
"Rowland Costin" <technical@.selven.co.uk> wrote in message
news:eA8CksEwFHA.3400@.TK2MSFTNGP14.phx.gbl...
> Trying to restore a database from a personal edition SQL 2000 to another
> PC. I get the following message
> The media set for database 'TeamSpiritDataTDB' has 2 family members but
> only 1 are provided. All members must be provided.
> What does this actually mean. Is the file corrupt, or is there a problem
> with the way it was backed up? I didn't back it up, but our normal
> procedure in this circumstance is just to make a complete back up to a
> file.
> Any ideas gratefully received.
> Thanks
> Rowland
>|||Thanks for the reply. The database backup in question was just a couple of
megs and was copied to CD. So I guess it must have been corrupt in some way,
cos it was backed up to file on the hard drive first. Still I guessed
something like this so fortunately as it was just a transfer of database and
not a real backup, we just got it backed up again and all was ok. Weird huh.
Cheers
Rowland
"Nik Marshall-Blank (delete fcom for my email address)"
<NikMB@.fcomiNodefcom.afcomt> wrote in message
news:dx8_e.116793$CC2.95087@.fe08.news.easynews.com...
> The backup was take to multiple disks and you have provided only one.
> http://forums.databasejournal.com/history/topic.php/33896-1.html
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Rowland Costin" <technical@.selven.co.uk> wrote in message
> news:eA8CksEwFHA.3400@.TK2MSFTNGP14.phx.gbl...
>> Trying to restore a database from a personal edition SQL 2000 to another
>> PC. I get the following message
>> The media set for database 'TeamSpiritDataTDB' has 2 family members but
>> only 1 are provided. All members must be provided.
>> What does this actually mean. Is the file corrupt, or is there a problem
>> with the way it was backed up? I didn't back it up, but our normal
>> procedure in this circumstance is just to make a complete back up to a
>> file.
>> Any ideas gratefully received.
>> Thanks
>> Rowland
>|||The error message clearly states that you striped the backup to two files and now try to restore
from only one of those files. It is easy to stripe by mistake, so instead of saying the backup is
corrupt, you might want to figure out why and who striped the backup by mistake and make sure it
doesn't happen again. If in doubt, you can examine the backup using
RESTORE HEADERONLY
RESTORE FILELISTONLY
RESTORE VERIFYONLY
RESTORE LABELONLY (this will tell you if the backup is striped)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rowland Costin" <technical@.selven.co.uk> wrote in message
news:%23$mxRm0wFHA.3152@.TK2MSFTNGP10.phx.gbl...
> Thanks for the reply. The database backup in question was just a couple of megs and was copied to
> CD. So I guess it must have been corrupt in some way, cos it was backed up to file on the hard
> drive first. Still I guessed something like this so fortunately as it was just a transfer of
> database and not a real backup, we just got it backed up again and all was ok. Weird huh.
> Cheers
> Rowland
> "Nik Marshall-Blank (delete fcom for my email address)" <NikMB@.fcomiNodefcom.afcomt> wrote in
> message news:dx8_e.116793$CC2.95087@.fe08.news.easynews.com...
>> The backup was take to multiple disks and you have provided only one.
>> http://forums.databasejournal.com/history/topic.php/33896-1.html
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Rowland Costin" <technical@.selven.co.uk> wrote in message
>> news:eA8CksEwFHA.3400@.TK2MSFTNGP14.phx.gbl...
>> Trying to restore a database from a personal edition SQL 2000 to another PC. I get the following
>> message
>> The media set for database 'TeamSpiritDataTDB' has 2 family members but only 1 are provided.
>> All members must be provided.
>> What does this actually mean. Is the file corrupt, or is there a problem with the way it was
>> backed up? I didn't back it up, but our normal procedure in this circumstance is just to make a
>> complete back up to a file.
>> Any ideas gratefully received.
>> Thanks
>> Rowland
>>
>|||Thanks Tibor.
I guess I didn't really understand the first reply. I didn't know you could
strip a backup, but I do now. I just tried it in enterprise manager and I
see what you mean. Its an easy mistake to make, if you add your own file and
the previous file is still there, it backs up to both files. Quite a handy
feature if you want to split over multiple media.
Thanks. I'll update our team member accordingly.
Regards
Rowland
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uKiDOx0wFHA.2620@.TK2MSFTNGP09.phx.gbl...
> The error message clearly states that you striped the backup to two files
> and now try to restore from only one of those files. It is easy to stripe
> by mistake, so instead of saying the backup is corrupt, you might want to
> figure out why and who striped the backup by mistake and make sure it
> doesn't happen again. If in doubt, you can examine the backup using
> RESTORE HEADERONLY
> RESTORE FILELISTONLY
> RESTORE VERIFYONLY
> RESTORE LABELONLY (this will tell you if the backup is striped)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Rowland Costin" <technical@.selven.co.uk> wrote in message
> news:%23$mxRm0wFHA.3152@.TK2MSFTNGP10.phx.gbl...
>> Thanks for the reply. The database backup in question was just a couple
>> of megs and was copied to CD. So I guess it must have been corrupt in
>> some way, cos it was backed up to file on the hard drive first. Still I
>> guessed something like this so fortunately as it was just a transfer of
>> database and not a real backup, we just got it backed up again and all
>> was ok. Weird huh.
>> Cheers
>> Rowland
>> "Nik Marshall-Blank (delete fcom for my email address)"
>> <NikMB@.fcomiNodefcom.afcomt> wrote in message
>> news:dx8_e.116793$CC2.95087@.fe08.news.easynews.com...
>> The backup was take to multiple disks and you have provided only one.
>> http://forums.databasejournal.com/history/topic.php/33896-1.html
>> --
>> Nik Marshall-Blank MCSD/MCDBA
>> "Rowland Costin" <technical@.selven.co.uk> wrote in message
>> news:eA8CksEwFHA.3400@.TK2MSFTNGP14.phx.gbl...
>> Trying to restore a database from a personal edition SQL 2000 to
>> another PC. I get the following message
>> The media set for database 'TeamSpiritDataTDB' has 2 family members but
>> only 1 are provided. All members must be provided.
>> What does this actually mean. Is the file corrupt, or is there a
>> problem with the way it was backed up? I didn't back it up, but our
>> normal procedure in this circumstance is just to make a complete back
>> up to a file.
>> Any ideas gratefully received.
>> Thanks
>> Rowland
>>
>>
>