Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore bombs

Author  Topic 

RoyalSher
Yak Posting Veteran

95 Posts

Posted - 2006-03-07 : 08:51:29
Hi everybody,

I am trying to restore bunch of files given by my tean. When I am trying to do a restore with the following command

restore database ic2_test from networkdevice01, I get errored out. The error is:

Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'ic2_test' has 7 family members but only 1 are provided. All members must be provided.

I took sometime to really understand, what exactly the DBA had given me to restore. Now, I decided to use the command

restore database ic2_test from networkdevice01, networkdevice02, networkdevice03, networkdevice04, networkdevice05, networkdevice06 to overcome the earlier error.

Well, it bombed again..with an error

Server: Msg 3227, Level 16, State 1, Line 1
The volume on device 'networkdevice03' is a duplicate of stripe set member 2.

I did google around for sometime, but I haven't seen any documentation to get this fixed. Can somebody guide me to restore this type of backup files?

Thanks in advance!

RoyalSher.
*********
The world is the great gymnasium where we come to make ourselves strong.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-03-07 : 11:11:19
uhmm... shouldn't the DBA do the restore for you?

just asking

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -