restore database problem 2

• jzhou

  SSCommitted

  Points: 1863

  More actions

  July 3, 2002 at 4:30 pm

  #105086

  I tried to restore a new version of the database to my server and get the following error message:

  The media set for database 'testdb' has 2 family members but only 1 are provided. All members must be provided.

  What is wrong here and how to fix this problem?

  Thanks.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 4, 2002 at 5:36 am

  #432112

  From what I could find you "striped" the backup. Take a look at this thread:

  http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=%23lWnpTkoAHA.1456%40tkmsftngp03&rnum=7&prev=/groups%3Fq%3Dsql%2Bserver%2BThe%2Bmedia%2Bset%2Bonly%2B1%2Bare%2Bprovided.%2BAll%2Bmembers%2Bmust%2Bbe%2Bprovided.%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D%2523lWnpTkoAHA.1456%2540tkmsftngp03%26rnum%3D7

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn